ODBC connector does not support rollback
Original Reporter info from Mantis: BigChimp
-
Reporter name: Reinier Olislagers
Original Reporter info from Mantis: BigChimp
- Reporter name: Reinier Olislagers
Description:
See example program: code snippet:
Q.SQL.Text:='INSERT INTO TEST (ID, DESCR) VALUES(3, ''This should be rolled back'')';
Q.ExecSQL;
Tran.RollBack;
rollback has no effect (the inserted row should not appear in the database but it does.
Attached program is written with an MS Access database but should run with minor modifications on other ODBC dbs
Additional information:
See forum thread http://lazarus.freepascal.org/index.php/topic,19100.0.html
OP posted: "I have not tried the last example because the management for rollback is missing in ODBCCONN unit"
Mantis conversion info:
- Mantis ID: 23429
- OS: Windows
- OS Build: Vista
- Build: r23110
- Platform: x64 (with x86 compiler)
- Version: 2.7.1
- Fixed in version: 2.6.4
- Fixed in revision: 23946 (#dc626fb1)
- Target version: 2.7.1