Andre,

Just something to think about....

If you are taking a generator and storing it in a table once it's used, why
not just populate a table with sequential numbers, and update the status to
completed after you have picked one, which is all possible to do in a
transaction....

Just an idea!

________________________________________
From: Andre du Plessis [mailto:andre@...]
Sent: Wednesday 25 February 2004 03:12
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Generator Integrity

I looked on the IBObjects site and don't know where to find this,
I suppose the FAQ search page is the right place but it only works by
selecting categories etc, there are too many, I looked in the keyword search
and only found things for Locking rows,

I actually wanted to achieve this without locking records

Maybe you have a url to the article you suggest?

thanks