Hello,

we solve the problem? Do I use better the CursorAdapter or SQL Pass Through in MM71?

SQL PASS THROUGH:

lcstring='sting'
lcoldsting='oldstring' && the value before the changinge by the user

lcSQL="UPADTE Table Set field=lcstring Where primaryKey=lnid and field=lcoldsting"

SQLEXEC(lnConnection,lcSQL)

So the record will change only if no other user changes the same field. How do I receive a message that an other user has changed the field?

Thank you for helping!

C.Przioda from Germany