Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RECALL cascade?
Message
 
 
To
09/06/1999 17:18:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00228161
Message ID:
00228354
Views:
15
>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
Map
View

Click here to load this message in the networking platform