Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Ideas for a Trigger
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00144206
Message ID:
00144281
Vues:
26
>How would one Update a field in a table, whenever
>that record has changed? I.E. If I update info
>regarding a payment balance, I would like the
>Database to update that tables' tbl_LstChange with
>a Datetime() Value...
>
>Can someone please point me in the right direction??
>
>Thanx,
>Bob :-)

You can't update a field from a record's trigger, or you would again fire the trigger. (Endless loop). You can do this from the validation rule though...

Make the table's record validation rule

TimeStamp()

and make a stored procedure in the dbc:

PROC TimeStamp
REPLACE tbl_lstChange WITH DATETIME()
RETURN .T.
ENDPROC
Erik Moore
Clientelligence
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform