General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I guess, your only option (if you really want to autonmate it) is to write your own UPDATE trigger which may search through the child tables, recalling some records there. This way you probably will flag this trigger procedure to prevent unwanted 'recall' cascading.
Well, here's an update...I've put in some extra code that will invoke the recall on the child table itself, here's the whole bit:
IF DELETED()
RECALL
thisform.refresh()
IF "SSU"$LCALIAS &&tests to see if we're in the table that's a parent table
SELECT CMSER
RECALL FOR CMSER.SBSERNUM=ALLTRIM(LCVAL)
SELECT &LCALIAS
ENDIF
Explaination of above, I have 3 tables I'm working with, when I'm accessing the parent(SSU), which is stored in LCALIAS, I select the child table, then LCVAL is holding the value of the Serial # that was recalled in the parent table. All this ONLY takes place if the record that I seek for is DELETED.
The above works, but not without failing a trigger, I'm not sure why...because the ser# is recalled in the parent first, so I'm not trying to add(insert?) something to the child that's not in the parent...Anyone have any clues????
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only