How to get the table names of a connectedd database?

[David Bovill]

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
> trevor at mangomultimedia.com
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>