On Tue, 2009-06-30 at 09:11 +0200, Frank Schönheit - Sun Microsystems
Germany wrote:
> 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
>
Yeah, that is the exact problem. I just find it a pain to deal with.
When I use MySQL Query Browser I don't use them, and it does not place
them in my code for me.
Thanks for the explanation.
Keith
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
