Whoops, no sorry, I confused you and David Hay, who tried to defeat
generators through locking tables rather than acquiring the next generator
number before an insert. Your only minor mistake is to try using an SP
rather than a script to set a generator value. So just keep on using Fb as
you currently do and continue to convince all your customers about the
strengths of Fb and IB!

Set

At 13:01 29.04.2003 +0200, you wrote:

>Make no mistake, I love FB and Interbase. :-) I am interested in why you
>say I am using it to plow the fields :-) I have convinced all my clients to
>use FB - having used MS SQL (various), MySQL, PostgresSQL and Oracle, I
>think FB (and IB) ROCKS!
>
>Rule #1 - I can always learn something new. So I would like to learn how to
>use it as intended.
>
>
> >By the way, Firebird is a great database that we jokingly called a "Sports
> >tank" in some of these newsgroups some time ago. I'm impressed by how you
> >try to twist this "sports tank" so that it can be used as a tractor to
> >plough the fields. It works a lot better once you try to use it as intended
> >(work with Firebird, not against it). ;o)