Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Click the link below to see the new game I'm developing!

Table name as a Variable in a SQL statement

Started by Vlodik Zmyslony, Apr 06 2001 02:39 PM

Reply to this topic

2 replies to this topic

#1 Vlodik Zmyslony

Member

Members
28 posts

Gender:Male

Posted 06 April 2001 - 02:39 PM

Within an SQL statement from ProIV it is not possible to send the table name as a variable in the select statement.
i.e.
select * from :$NAME
This won't work. Has anyone been able to somehow dyamically pass the table name to build up the SQL statement in ProIV?

#2 Guest_chris mariano_*

Guests

Posted 11 March 2006 - 07:09 AM

dnt know if this would work ...

$sql_str = 'Select * from '
$sql_str = $sql_str + $table_name

sql
execute immediate :$sql_str

endsql

...or something like that..

#3 deepghosh

Member

Members
37 posts

Gender:Male

Posted 13 March 2006 - 03:44 AM

Look for SQL DYNAMIC

Back to Questions

Reply to this topic

1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users