How to get the table names of a connectedd database?

[Trevor DeVore]

On Jan 24, 2006, at 1:00 AM, Ruslan Zasukhin wrote:
>
>> Valentina 1.x, on the other hand (which is not SQL92
>> compliant), will accept single quotes around a table name.
>
> Actually Valentina 1.x around Table Names and Field Names expect
> to see [] -- this is oracle Style.

Good to know.  I've modified libDatabase accordingly.  Valentina  
apparently accepts single quotes around the table name without  
complaining though (at least running trough ViSQL).  It does not like  
single quotes around column names though.

> Valentina 2.x which is SQL92 compliant use next rules:
>
>     string constants: always single quotes  ''
>
>     delimited identifiers:  "" -- SQL92
>                             [] -- Oracle Style.
>
> I.e. You cannot and should not use single quotes around field/table  
> names.

Now SQLite, PosteGreSQL and Valentina 2 use double quotes, MySQL uses  
` (libDatabase only adds quotes to queries that are generated at  
runtime from arrays so portability won't be a concern as far as the  
library is concerned) and Oracle and Valentina 1.x use oracle style  
[].  I'm not sure what Oracle support is for double quote (I assume  
it supports it) but I don't use it or have the docs so I'm leaving it  
at [] until somebody confirms Oracles preferred quotes.

I've uploaded version 2.0.1.16 of libDatabase to <http:// 
www.mangomultimedia.com/developer/revolution>.  This fixes the  
quoting issues mentioned above.


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