Use A GUID for a priimary key - then you don't have to worry about sequence or duplicates for a thousand years or so. It's built into the standard.

Integer tokens are nice for centralized work, but they are a poor choice for anything that needs to merge potentially disconnected databases.

----- Original Message -----
From: Lee Jenkins
To: firebird-support@yahoogroups.com
Sent: Thursday, April 22, 2004 11:42 PM
Subject: [firebird-support] Synchonizing my generators



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



------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]