I've thought about that, but that would be much work changing the database
structure which I would be willing to do, except for the prospect of
upgrading hundreds and hundreds of clients! I may use them in some upcoming
projects though. Isn't there a UDF for this?

And thanks for the response, I appreciate it.

Lee

----- Original Message -----
From: "David Johnson" <d_johnson@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, April 23, 2004 11:42 PM
Subject: Re: [firebird-support] Synchonizing my generators


> 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]
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>