SQLDB SqlQuery rowsaffected problem
Original Reporter info from Mantis: k1attila1
-
Reporter name: Kovács Attila
Original Reporter info from Mantis: k1attila1
- Reporter name: Kovács Attila
Description:
Please read it :
http://www.lazarus.freepascal.org/index.php/topic,21122.0.html
SqlQuery don't work properly at "readcommited" isolation level, because you can't read the affected rows afterupdate,afterdelete,afterinsert.
Why is it important ?
It could be only 1 or 0 saved record.
1 : everything is ok, record is saved
0 : 0 row AFFECTED . I realized that, if an update isn't succesfully (e.g. :Firebird can't find the record according to the WHERE parameter) it won't raise error .
It is only cause : "0 row(s) affected" without exception.
This cause "lost update" problem.
At "repeatable read" level it isn't problem, because record lock solve this problem.
Mantis conversion info:
- Mantis ID: 24577
- Platform: Win32
- Version: 1.0.8