At 04:15 PM 01-08-01 -0600, you wrote:

>Im doing a startTransaction... Then if something happens, Im calling a
>rollback.

Gordon, please show us (a) the SQL and (b) the code for processing the transaction. Also please tell us what CommitAction you have on the transaction.

>The next time I call my routing, it again calls a starttransaction. I get an
>exception that says that a transaction is already being used (or something
>like that)
>I found that by simply doing a commit after my rollback, it works perfect
>now. BTW, this is after calling a stored procedure, using a TIB_cursor ..

Calling COMMIT after ROLLBACK should raise an exception. If this isn't the case, then your ROLLBACK call is not being made. What does the SQLMonitor show?

Regards,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________