Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Triggers executed when packing
Message
From
25/05/2007 10:42:17
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Triggers executed when packing
Environment versions
Visual FoxPro:
VFP 6 SP5
Miscellaneous
Thread ID:
01228505
Message ID:
01228505
Views:
62
I found this strange - calling a specially crafted function from the trigger expression (for debugging purposes), I found that in one table, when issuing a PACK, the update trigger was executed several times; in another table, it was not. In both cases the tables had both deleted and non-deleted, records.

Does anyone know on what this would depend - whether the update trigger would be executed, or not? And why would this particular trigger be called in the first place?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Next
Reply
Map
View

Click here to load this message in the networking platform