I am using a databaseconnection via ODBC to Sybase ASA 9.01
After updating a dataset and updating fails against table T1 ( Primary key
would not be unique ! ),
This is OK, That can happen in my program.
But after five Minutes,
I use the same connection for another Query to Table T2.
Now I get the OLD errormessage from Table T1 !!!


Is there a ROLLBACK needed or something else.

What i have to do, when an update of a dataset fails ??

Thanks for any help

Peter Stojkovic