Greetings,



I apologize up front is this has been a beaten subject.



I have a customer that reports from time to time that my application is
issuing the same Order Number. The order number's source is a generator.



My application (using a very old version of IBO):

1) Creates a Transaction object in code. (default AutoCommit is False)

2) Creates a cursor object in code and assigns the above transaction.

3) The cursor component calls a stored procedure which calls gen_id:

EndOrderNo = gen_id(gen_orderno, :InOrderCount);

4) The Transaction component's "Commit" method never gets called. This
is probably my error however I thought generator calls/increments are
outside of the transaction.



Can someone confirm the errors of my ways? Thanks in advance!



Kevin



(Sorry for the original post in FB - General)



~~~~~~~~~~~~~

Kevin Stanton

RDB Solutions

P: 503-705-0834

F: 503-822-0178





[Non-text portions of this message have been removed]