ChrisJRutter
Member
When doing a refresh on a browse with related tables I am finding the whilst the main query refreshes fine, the related table does not seem to refresh.
eg
OPEN QUERY br_1 FOR EACH table_a NO-LOCK,
FIRST table_b NO-LOCK WHERE table_b.code = table_a.code.
DISPLAY table_a.code table_b.descr
Now run some sort of update procedure that changes table_a.code, then meth_return = br_1:REFRESH().
New table_a.code displayed but table_b.descr stays the same unless I either reopen the query or do a
FIND FIRST table_b NO-LOCK WHERE table_b.code = table_a.code in the ROW-DISPLAY trigger.
Can anyone tell me what I'm doing wrong?
eg
OPEN QUERY br_1 FOR EACH table_a NO-LOCK,
FIRST table_b NO-LOCK WHERE table_b.code = table_a.code.
DISPLAY table_a.code table_b.descr
Now run some sort of update procedure that changes table_a.code, then meth_return = br_1:REFRESH().
New table_a.code displayed but table_b.descr stays the same unless I either reopen the query or do a
FIND FIRST table_b NO-LOCK WHERE table_b.code = table_a.code in the ROW-DISPLAY trigger.
Can anyone tell me what I'm doing wrong?