--- In firebird-support@yahoogroups.com, "women_lover_best"
<talbronstien@g...> wrote:

> Hi,
> I would like to know whether one should go with generators, or should
> we generate id's using our own function..the latter option will be
> good if we need to migrate to a different database..
> thks
> vishy

Use Generators,

They are the easy to use, multi-thread, multi-connection and multi-
transaction safe. The concept is also now included in the SQL standard
as "SEQUENCES", Firebird 2 introduces the Get Next Value For [Sequence]
syntax.

If you do decide to write your own, you would probably need to
implement a UDF to get the value, but make sure it is threadsafe!!!. If
you are currently implementing another DB, then check whether they
support the concept.


Adam