Subject | Synchonizing my generators |
---|---|
Author | Lee Jenkins |
Post date | 2004-04-23T06:42:11Z |
Hello all,
Sometimes we need to import data into our database and many times the key
primary key field is supplied during the import. Is there a way for me to
check each generator against the table that uses it, see what the highest
value of the pk field is and increment the generator used for that field by
one more?
Or is it something I will to hard code for each table? I would be nice to
create either a SP or a tight looping routine from the client do it.
Thank you for any suggestions,
Lee
Sometimes we need to import data into our database and many times the key
primary key field is supplied during the import. Is there a way for me to
check each generator against the table that uses it, see what the highest
value of the pk field is and increment the generator used for that field by
one more?
Or is it something I will to hard code for each table? I would be nice to
create either a SP or a tight looping routine from the client do it.
Thank you for any suggestions,
Lee