Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBC Triggers and RI
Message
 
 
To
03/01/2013 15:17:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01561335
Message ID:
01561337
Views:
63
>In the brief period when I used DBC/DBF I never used the RI or triggers. Didn't trust them. (Steve Sawyer once gave a great presentation on why that distrust was well-founded)
>
>Now use them even less :-) but a couple quesitons
>
>Are there any circumstances when they do no fire.
>
>For example ; Sql insert / delete from a table. Should it fire the RI code to delete children?
>
>Browse, mark record as deleted. RI fire?
>
>Manual insert / update ?
>
>TIA

I believe in all these cases the RI triggers should fire. Did you find a case when it's not so?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform