Hi Keith,
> Is there a way to have Base not use the ` character in SQL?
Base uses whatever the database driver tells is the proper quoting
character for identifiers. While in some situations, it would not be
strictly necessary to add those quoting characters (i.e. change a
|SELECT field FROM table| to |SELECT `field` FROM `table`|), Base tries
to be on the safe side by always adding them.
If you don't want this, then you need to use "native" statements
("Execute SQL directly" option in the query designer's SQL view).
Alternatively, your database/driver might have an option to use
alternative quote characters, if you just to not like the ` in
particular. For instance, MySQL usually allows to switch to an ANSI
quote character (and I assume you're talking about MySQL here, since
that's the only database I know which uses ` in its default setup).
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]
