> -----Original Message-----
> According to Helen book short article "how to mess up with
> your database " , there should be added out this one :
> a) Give to your variables, tables, domains, columns SP,
> triggers or any of metadata objects same names where possible.
> b) Give to your variables, tables, collumns SP, triggers or
> any of metadata objects names which are close or identical to
> any of the reserved words, like "type,subtype,year, all,
> first,user,sum,time etc etc ".

Most (all?) languages have reserved words, in Delphi, you couldn't use

var
record: Integer;

Because record is a reserved word, FB is just the same in this respect. You
can always use dbl quotes if you wanted, but lets face it, a column name of
time is pretty ambiguous, especially when seeing the results of several
joined tables.

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://sourceforge.net/projects/dnfBB - Web based, Firebird Powered Forum