URGENT Locking two tables when they are joined using query
HI ,
I was trying to change a unique record using two different session.
The Frame is like this
Customer Customer Name Address
00000001 Abcd Xyz
There are two table which are joined by a query,
When I change the customer records the message does not get displayed but the message get displayed for the address.
here the message come when the address record is changed.
but the message does not come when customer record is changed.
Program
define query q for customer fields( customer_id customer_name),address fields(adress) scrolling.
open q .... .
if available customer then get current q no-lock.
if available customer and (current-changed customer
or current-changed adress) then do:
message "record locked changed".
end.
I want to get the messages when either the customer record or the address is changed in one of the session when the same record has already been changed in other session.
HEPL MW HOW TO D THIS?
HI ,
I was trying to change a unique record using two different session.
The Frame is like this
Customer Customer Name Address
00000001 Abcd Xyz
There are two table which are joined by a query,
When I change the customer records the message does not get displayed but the message get displayed for the address.
here the message come when the address record is changed.
but the message does not come when customer record is changed.
Program
define query q for customer fields( customer_id customer_name),address fields(adress) scrolling.
open q .... .
if available customer then get current q no-lock.
if available customer and (current-changed customer
or current-changed adress) then do:
message "record locked changed".
end.
I want to get the messages when either the customer record or the address is changed in one of the session when the same record has already been changed in other session.
HEPL MW HOW TO D THIS?