Hi,

This problem has nothing to do with IB or FB. You use an SP to update the
number. Transactions can not "see" each others transactions until commit, so
you'll be wrong in your number here (at least in a multiuser environment).

Use a generator to generate your billing numbers, they work outside
transaction scope and are garanteed unique.

Also don't use your billingnumber as a PK, but use a trigger and generator
for your PK.

There is an excellent article on this topic at the IB site
(www.ibojects.com).

Benno

----- Original Message -----
From: "Svein Erling Tysvaer" <svein.erling.tysvaer@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, January 03, 2003 1:47 PM
Subject: Re: [ib-support] Number Skipping


> Sivaraman,
> go to http://www.ibobjects.com/TechInfo.html and download "An Auditable
> Series of Numbers". It shows you how to enforce sequential numbers.
>
> I am a bit puzzled by you using IB 6.0. Firebird 1.0 is basically a
> bugfixed version of IB 6.0, whereas Borland has released newer versions of
> Interbase. I am not saying that IB 6.0 is bad, but you can get better -
> either for free (Firebird) or by paying for it (Interbase).
>
> HTH,
>
> Set
>
> - I support Firebird, I am a FirebirdSQL Foundation member.
> - Join today at http://www.FirebirdSQL.org/Foundation
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>