Information générale
Catégorie:
Codage, syntaxe et commandes
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement