How to get the table names of a connectedd database?

Trevor DeVore lists at mangomultimedia.com
Mon Jan 23 22:40:21 EST 2006


On Jan 23, 2006, at 7:44 AM, David Bovill wrote:

> 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.

You are right, the SQL standard does specify double quote.  MySQL on  
the other hand prefers the ` character (numToChar(96)).  It will only  
accept double quotes if ANSI_QUOTES is enabled on the database  
server.  Valentina 1.x, on the other hand (which is not SQL92  
compliant), will accept single quotes around a table name.

-- 
Trevor DeVore
Blue Mango Multimedia
trevor at mangomultimedia.com





More information about the use-livecode mailing list