Home » Developer & Programmer » Forms » ON-LOCK/lock_record not working after set_record_property QUERY_STATUS
ON-LOCK/lock_record not working after set_record_property QUERY_STATUS [message #684720] Tue, 03 August 2021 15:18
miersuzzemes
Messages: 8
Registered: July 2013
Location: Latvia, Riga
Junior Member
In a summary: I edited a database item, ON-LOCK trigger fired, and then executed:

set_record_property(get_block_property('my_block', current_record),'my_block',status, QUERY_STATUS);

And after that whenever I edit any database item in that record or even programmatically call LOCK_RECORD, the ON-LOCK trigger is not firing.

Why am I even doing this, is another story, but is there some other place (record property) where Forms store info that "this record has already been locked"? There is no way that Forms check something in the database, because in my ON-LOCK trigger I have left just a debug message.
Previous Topic: Upload an image
Next Topic: How to resolve the ora-305501 error
Goto Forum:
  


Current Time: Thu Mar 28 05:11:44 CDT 2024