Hello all,
maybe this question is offlist, but I'm not sure...
I use RB to develop client application connected to MySQL (5.0)
I'd like the users to browse all data in db as freely as possible,
but when a user wants to edit a record, she has to lock it first and
the record remains locked as long as she has not finished (=
release). If another user tries to edit the very same record, she
must have a message saying that she cannot edit this record because
it is locked.
I tried
"SELECT * FROM myTABLE WHERE ID = " + theID + " FOR UPDATE"
and
"SELECT * FROM myTABLE WHERE ID = " + theID + " LOCK IN SHARE MODE"
on 2 different clients, but MySQL keeps on returning a valid cursor
Thanks for your help
Eric
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
