Is there a way to lock at the record level? I know that you can lock at the table level:
&sql(UNLOCK mytest IN EXCLUSIVE MODE)
but am unable to find a way to lock just at the record/row level.
Would this also affect a SELECT statement done on the record?