MySQL connection read remote commit

[xinyiman]

Hello everybody. I have a small problem with the standard components of lazarus for connecting to MySQL. Example of the problem:
I have two clients (client A and client B) that access the same table on the database.
If I make a change to "Client A" then I do Query.ApplyUdates; and Transaction.CommitRetaing; and then on the "Client B" I close and reopen the query I don't see the updated result. I think it's an isolation level problem so I don't read remote commits. But how do I fix it?

[valdir.marcos]

Hello everybody. I have a small problem with the standard components of lazarus for connecting to MySQL. Example of the problem:
I have two clients (client A and client B) that access the same table on the database.
If I make a change to "Client A" then I do Query.ApplyUdates; and Transaction.CommitRetaing;

Use Commit instead of CommitRetaing.

and then on the "Client B" I close and reopen the query I don't see the updated result.

On "Client B", try commit [close] and reopen.

I think it's an isolation level problem so I don't read remote commits. But how do I fix it?

Transactions have numbers.
B must have a bigger number than A, so B can see what A did before, that's why you must commit B and reopen to see what A did before.

[dogriz]

If I make a change to "Client A" then I do Query.ApplyUdates; and Transaction.CommitRetaing; and then on the "Client B" I close and reopen the query I don't see the updated result.

Closing and opening Client B Query is not enough. Close and open B transaction too.