|Subject||Re: [ib-support] Idea for a new field type for FB 2,0 or IB 7?|
> Generators are used almost 90% of the time to have a unique identifier ofa
> row. Don't you use (the superior mechanism) generators on a "BeforeInsert'
> trigger ? Everytime you define a generator don't you have to go and changeI use a very cheap and handy tool for that. I design my tables using dezign
> 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)?
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
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 www.datanamic.com
> Save Time!