?'s re Record Locking

Das Goravani goravanis at gmail.com
Sat Jul 2 19:35:06 UTC 2022


Dear List,

When you have a SELECT statement with "FOR UPDATE" at the end, and you use $execdirect or $prepare…

How do you tell if a flag false is returning a record lock verse simply a lost connection?

As far as I know the flag false on such a SELECT statement could indicate there is a bad connection to the database, and also it indicates that the record is locked, and I can’t figure out in code which is which. ???

How do you tell if the record is locked? I’m assuming it’s FLAG FALSE on the $execdirect. 

What do you do if the record is locked. I’m working with Remote Forms, the Javascript Client.

Thank you,

Das Goravani


More information about the omnisdev-en mailing list