Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Complex Table Row Validation Question
Message
 
À
13/12/1998 11:53:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00166949
Message ID:
00167021
Vues:
34
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
Fil
Voir

Click here to load this message in the networking platform