Hi Ariel, >> OK, in parsing mode I can leave out the doublequotes around identifiers. > > only if you are sure that the server will find your identifiers > (tables/fileds/...) > > in native SQL > > SELECT myfield FROM mytable > > will be read by the server as > > SELECT MYFIELD FROM MYTABLE
That's true for HSQL, not necessarily for other RDBMSes. However, you're right in that when you (or Base) quotes the identifiers, then the engine won't touch them. If you don't quote them, then engine is free to "normalize" them, which might or might not be making them upper-case. > My practice is to use Tools - SQL to create tables. > But can OOo Base be configured so that the table designer will not quote > identifiers (default behavior)? I will have to find out... No. If the database/driver tells there is a character to quote identifiers, then it will be used. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
