Why 'Zap' works with 'Delete' set to 'Restrict' in RI?

[rnathan]

Hi

I have a DB container (VFP 6.0) in which I have set up the Delete trigger to 'Restricted' for two tables in the Referential Integrity Builder. These two tables have parent-child relationship. What I noticed was I was able to zap the parent table (shocking...) but when I tried to delete a record from the child table I got the Trigger Failed error as I expected. My question is why Zap didn't give me a 'Trigger Failed' error?

Rita

 

[ramani]

Hi Rita,

By very creation of this command, the manual specificaly says, that the trigger will not be activated. ZAP is used only when a table need to be cleared. No RI triggers will be called.

However, if you need to do RI checks, then you should use.. DELETE ALL command instead of ZAP command.
Then do a PACK. Remember to open the table exclusively.



____________________________________________
Ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/

When you ask VFP questions, please add VFP version.

 

[rnathan]

Thanks Ramani.. that sure answered my question..

 

[Mike Lewis]

Rita,

It is also worth noting that PACK does not fire any triggers (which perhaps is not surprising) ... and neither does RECALL.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[rnathan]

Thanks Mike. I wasn't aware of this fact.