The ` character removal

[Keith Clark-2]

Is there a way to have Base not use the ` character in SQL?

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Frank Schoenheit, Sun Microsystems Germany]

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         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

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: users-unsubscribe@...
For additional commands, e-mail: users-help@...