I've checked transaction isolation level - that's reason
Thank you for help
Search found 3 matches
- 10.01.2007, 08:49
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: SELECT query returned data with deleted records
- Replies: 4
- Views: 675
- 10.01.2007, 07:33
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: SELECT query returned data with deleted records
- Replies: 4
- Views: 675
mdaems, thank you for your reply The engine is InnoDB. I've restarted mysql server again. I don't understand why but transaction really is not being committed. I've tried again - start transaction; delete ... ; commit on the mysql-server and well done SELECT-query works properly from mysql-server an...
- 09.01.2007, 21:50
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: SELECT query returned data with deleted records
- Replies: 4
- Views: 675
SELECT query returned data with deleted records
Hi! Downloaded and installed successfully ZeosLib 6.6..0beta into Delphi 7.0 for using with MySQL 5.0 Got strange issue: when I run SQL-query on server the query returns 11 actually records But when i run the same query from delphi program query returned 13 records (11 actually and 2 recently delete...