Update & SQL

[Bart Pietercil]

Hi Ruslan,

Wondering how Valentina handles locks when using the update sql syntax.


If a lock has been set on a record and using sql (update..... where  
recid = lockedrecordrecid) what will happen?

I know I could build a cursor that is readwrite but the update sql  
syntax refers to a tablename. There seems to be no way to say in sql

update mycursor set.....

Confused

TIA

Bart Pietercil