General information
Category:
Coding, syntax & commands
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only