Helen Borrie wrote:

> At 07:49 PM 12-07-02 -0400, Thomas Miller wrote:
>
> >And your real problem. You should make all your database objects have
> >an "_" (underline)
> >in the name. I have yet to see a key work with an underline in it.
>
> Oooh--er. We have the context variables CURRENT_TIMESTAMP, CURRENT_TIME,
> CURRENT_DATE and CURRENT_USER which are reserved.

That stincks :-) . I guess I will have to be more careful in the
future. Oracle doesn't have any keywords
with "_" in them.

>
> The safe thing to do - regardless of whether you are using InterBase,
> Firebird, MSSQL Server, Oracle...or whatever...is to make yourself
> acquainted with the keywords *before* you start making "commitments" in
> your code. Anyone working in SQL should, as a minimum, treat every
> keyword
> in standard SQL as reserved, even if currently isn't reserved in the
> particular RDBMS being used.

Agree totally. You also have to be mindful that new key words will be
added.

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com