Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Complex Table Row Validation Question
Message
 
To
13/12/1998 11:53:11
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00166949
Message ID:
00167021
Views:
40
Hi Andrew,

>
>Why would I do this via the update trigger instead of a row rule?
>

Please read the VFP help contents .

-> record-level rule

A validation rule, bound to a record, that is activated when a record is inserted or changed, and most often used to verify data entry and correctness.
Validation rules do not apply when records are deleted.
Record-level rules are activated after field-level rules and before triggers,
and work during buffered updates

-> trigger

Record-level event code that runs after an insert, update, or delete.
Different actions can be attached to the different events. Triggers run last,
after rules, and do not run during buffered updates unless TABLEUPDATE( ) is issued.
They are most often used for cross-table integrity.

Why don't you simply use your validation view in the update trigger ?

A trigger runs after insert, update ( so all data is in the table when you Requery your view )

Marcel
Previous
Reply
Map
View

Click here to load this message in the networking platform