At 04:26 PM 7/27/2005, Dennis Fleming wrote:
RB7.1
On a two table form. PK - table A, FK - table B (in scrolling region).
There is a button to "close the work order" and one row is deleted in
table A and one or more dependent rows in table B. The EEP does:
PROPERTY TABLE tableA "REFRESH"
PROPERTY TABLE tableB "REFRESH"
and the next row in table A is displayed properly but the table B
scrolling region is blank (until you next row, previous row). I
tried a number of different refresh techniques, but looking for the
recommended method.
Dennis,
In a situation like PK/FK, I suggest that you define a CASCADE for
the table with PRIMARY KEY.
ALTER TABLE <TableNamewithPK> ADD CASCADE
Adding the CASCADE option will maintain the Primary/Foreign Key
relationships automatically. For example, if you either update
or delete a Primary Key value from this table, the corresponding
Foreign Key values are updated or deleted automatically.
In this case you ONLY need to delete the row from Primary Table
and let the R:BASE Engine do the rest for you.
Then, you can use the following:
PROPERTY TABLE FormTableA 'REFRESH'
PROPERTY TABLE FormTableB 'REFRESH'
RETURN
Very Best R:egards,
Razzak.
