Subject Re: [firebird-support] Some explanations Needed
Author Thomas Beckmann
> when we use generator,why do we use syntax like..
> if
>,1)..why not just use 2nd line?
You can definitely use the second line only, but must people use this
statement in there BeforeInsertAndUpdate-trigger and therefor have to make
sure, the id does not get changed during updates.

> Also,I want to make sure that values in a column are can I
> do that beside using primary key(as another column is being used as
> primary key)and unique index(assuming only one uniques index is allowed
> per table)..
AFAIK you can have as many UINQUEs on a table as you want. But anyway: You
can make sure by using a before InsertUpdate-trigger checking for an
exists(select FIELD from table where FIELD=VALUE) on your FIELD and VALUE.

> Why does firebird does not have a boolean type?
It is not part of the standard.

> What is the difference between time and timestamp?
Someone else has to answer this one, I can't be exact enough in that
without looking at the manuals.

Martens & Prahl EDV, Wielandstr. 14c, 23558 Lübeck
Telefon 0451-39904-525 • Telefax -520/-559