Thanks for the help!
NB - AFAIK PostGres and quoting goes like this - think it is the same
for standard SQP? Single quotes for text values and double quotes for
Table Names - if you don't have funny character, spaces or reserved
words in the table names you do not need to quote them - but single
quotes for table names is a no-no.
On 23 Jan 2006, at 16:01, Trevor DeVore wrote:
On Jan 23, 2006, at 6:44 AM, David Bovill wrote:
function database_GetTableNames tObjects
-- gets from QueryObject not directly from live database
-- so use Database Query Builder Tools first
put revTableNamesOfQuery(tObjects) into tableList
return tableList
end database_GetTableNames
This does the job - but you have to use the "Database Quesry
Builder"? How is this done directly in transcript - anyone got
some handlers having problems debugging the Query Builder :)
Undocumented function revdb_tablenames(theConnectionID).
--
Trevor DeVore
Blue Mango Multimedia
[EMAIL PROTECTED]
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
