Why not just add a onenter event handler to the forms field in question and just check the data before they edit it. If it's different update the field with the most current data.
Access probably just does something similar under the hood for you. I don't think that's a feature of the ODBC driver or is it?
If it is you could always use the ODBC driver from Delphi as well.
With Dephi/BDE/ODBC, this is different: as soon as you try updating a field that has been modified by someone else meanwhile, the field is automatically updated for you before you start making your own changes, and of course before you try to commit them. That's fine too. I would have preferred an error personnally.
Is there a way to do the same with ZEOS? Or maybe is there another mecanism that could be used to do optimistic locking? Some kind of "long transactions", in the database server?
Philippe Lang
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
