Subject | Is GeneratorLinks done on client? |
---|---|
Author | Jim Harlindong |
Post date | 2001-03-13T17:19:33Z |
Does GeneratorLinks work with a server before insert trigger?
I have a generator and a before trigger to assign it to the PK of a table.
I found that IBO incremented the generator before inserting and since I did
not include the field involved in the INSERT statement, the generator on the
server incremented the generator again (since the field is null).
My question is: Is it a good idea to increment the generator from the
client? Will there be a keyviol problem where two clients are simultaneously
incrementing the generator?
I suppose not since the generator on the server should be serialized.
However, is it possible for IBO to:
Perform insert (omitting the PK which is generated using server trigger),
then after that, loads up the value of this field from the server.
Thanks
I have a generator and a before trigger to assign it to the PK of a table.
I found that IBO incremented the generator before inserting and since I did
not include the field involved in the INSERT statement, the generator on the
server incremented the generator again (since the field is null).
My question is: Is it a good idea to increment the generator from the
client? Will there be a keyviol problem where two clients are simultaneously
incrementing the generator?
I suppose not since the generator on the server should be serialized.
However, is it possible for IBO to:
Perform insert (omitting the PK which is generated using server trigger),
then after that, loads up the value of this field from the server.
Thanks