BobyIsProgress
Member
Hi guys,
With the help of manie I know how to acces a data properly in the purpose of commit a new value.
Like this:
Now I would like to acces it for reading only. As of today I just write querry like this:
It works perfectly at the begining of a procedure. But when I did already a bit of data acquisition and other operation what is the best way to consult data when another user can changed it with an "EXCLUSIVE-LOCK".
So I need your help
Have a nice day
With the help of manie I know how to acces a data properly in the purpose of commit a new value.
Like this:
Code:
DEFINE BUFFER bCustomer FOR CUSTOMER.
DO FOR bCustomer TRANSACTION:
FIND bCustomer WHERE ROWID( bCustomer ) = ROWID( CUSTOMER ) EXCLUSIVE-LOCK NO-ERROR.
IF AVAILABLE bCustomer THEN DO:
bCustomer.value = new-value.
END.
end.
Now I would like to acces it for reading only. As of today I just write querry like this:
Code:
FIND FIRST customer WHERE customer.Id = 55 NO-LOCK NO-ERROR.
IF NOT AVAILABLE customer THEN
RETURN.
So I need your help
Have a nice day