Hi Josh, > What's the logic behind the query tool generating all-quoted identifiers?
as always, "Trying to be on the safe side, making more DBs happy than harming others". Or so. If the database (its driver, more precise) tells OOo that there *is* a quoting character for identifiers, then OOo will use it. > The "", in ANSI SQL, are used to denote an identifier which may have unusual > characters (such as a space or period), mixed case, or beginning with a > digit. However, if you quote an identifier on most systems (such as > PostgreSQL and Oracle) then the case of the quoted identifier must match the > real identifier exactly. I could imagine quoting only identifiers which have unusual (aka non-SQL-92) characters in it by default. /me is explicitly encouraging you to submit an RFE for this :). Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems, Inc. http://www.sun.com/staroffice - - OpenOffice.org Database Access http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
