Subject Re: [ib-support] Idea for a new field type for FB 2,0 or IB 7?
Author IBlist
> Generators are used almost 90% of the time to have a unique identifier of
> row. Don't you use (the superior mechanism) generators on a "Before
> trigger ? Everytime you define a generator don't you have to go and change
> your 'Before Insert' (or create a new one just for this) and put the line
> IF( new.blabla is null) then new.blabla=Gen_ID(....blablabla)?

I use a very cheap and handy tool for that. I design my tables using dezign
for windows,
and create scripts with that. In Dezign you use it's internal types and one
of them is autonumber.
You can choose the database it has to create for. If you choose Interbase,
it will create a generator and a
trigger for you. If you choose Oracle it will do it the way Oracle handles
these fields.

Advantage is you always have up to date documentation and a graph of your
tables and it's relations.

You can download a demoversion at

> Save Time!
It does..........
> Artur