Hi,
I am using the most new revision 187 of Zeos 6.6 with Delphi 5. I have only problems with the TransantIsolationLevel. I was starting with tiReadCommitted and went up to tiSerializable. I am using MySQL 4.1 but i also tried MySQL 5.0.
The point is, that I want, that if someone in the network is editing a row in a table nobody else should be able to edit this row. But it does not work, all can edit the same row. I also tried to work with:
Connection.StartTransaction;
and
Connection.Commit;
But still several people can change the same row in the same time, with the known problems of lostupdate.
So what i am doing wrong?
Thanks for every replay
PS: Oh i am using Protocol: mysql-4.1 (or mysql-5.0). When i try to use mysqld-4.1 or mysqld-5.0 I get a crash of the dll (access-error). Of MySQL I use mysqld and InnoDB so that the Database should be able to use Transactions.
How to work with TIL?
Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs
Moderators: gto, cipto_kh, EgonHugeist
-
- Fresh Boarder
- Posts: 19
- Joined: 18.10.2005, 23:37
Return to “6.5.1 (alpha) - 6.6.x (beta)”
Jump to
- Links
- ↳ Bugtracker
- ↳ Downloads
- ↳ Subversion
- ↳ GitHub
- ZEOS Library - General
- ↳ Announcements
- ↳ Downloads
- ↳ Documentations
- ↳ Tutorials
- ↳ ZDBC (ZEOS Database Connectivity)
- ↳ User Contributions
- ↳ Feature Requests
- ↳ User Patches
- ZEOS DBO v8.x
- ↳ ZeosLib 7.3/8.0 Forum
- ZEOS DBO v7.x
- ↳ ZeosLib 7.2 Forum
- ↳ ZeosLib 7.1 stable Forum
- ↳ ZeosLib 7.0 Stable Forum
- ↳ ZeosLib 7.0 Beta Forum
- SQL Servers and Databases
- ↳ ADO
- ↳ DB2
- ↳ Firebird
- ↳ Interbase
- ↳ MS SQL Server
- ↳ MySQL
- ↳ Oracle
- ↳ OleDB (Microsoft Windows)
- ↳ ODBC
- ↳ PostgreSQL
- ↳ SQLite
- ↳ Sybase ASE
- Compiler related
- ↳ CBuilder / C++
- ↳ Lazarus / Freepascal
- ZEOS DBO V 6.x
- ↳ 6.6 - stable
- ↳ 6.5.1 (alpha) - 6.6.x (beta)
- ↳ 6.1.5
- ↳ Other 6.x Versions
- ↳ Bug Reports
- ZEOS DBO V 5.x
- ↳ 5.x Versions
- Software projects using ZeosLib
- ↳ SQLite Administrator
- Other and Non-Technical
- ↳ Off Topic