Information générale
Catégorie:
Codage, syntaxe et commandes
Thanx Erik,
After I posted it I figured out what you said so its working great now...
Thanx a Bunch!
Bob :-)
>>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
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