Front end: VFP
Backend: Access, VFP, SQL or Oracle
Connection: ODBC
Problem: Having got the connection handle, we set sqlsetprop for transaction as manual to enable sqlcommit or sqlrollback. However, an abnormal termination commits the transaction distorting inter table integrity. Any way out ?


Rakesh