Subject | Unique gen_id name needed for each trigger? |
---|---|
Author | dleec45 |
Post date | 2004-05-22T18:53:33Z |
I'm trying to set up my first FB1.5 db and have a number of tables
that are being converted from MySQL where the key ID was auto
incriment. If I set up a trigger to do this function BEFORE INSERT,
do I need a unique generator id for each table as in:
NEW.ID GEN_ID(addr_gen_ID, 1);
In this example addr_gen_ID happend to be used my address table and
cannot be used as a generic generator for ALL tables? RIGHT?? I
can't find this anywhere in the docs.
Regards,
Lee
that are being converted from MySQL where the key ID was auto
incriment. If I set up a trigger to do this function BEFORE INSERT,
do I need a unique generator id for each table as in:
NEW.ID GEN_ID(addr_gen_ID, 1);
In this example addr_gen_ID happend to be used my address table and
cannot be used as a generic generator for ALL tables? RIGHT?? I
can't find this anywhere in the docs.
Regards,
Lee