You can not update the same table in the trigger. It can only be done in the table validation rule.
Re: Last Updated User Thread #
988451 Message #
989719>Hmmm....
>
>I'm getting a syntax error when trying to place this into the expression builder for the table update trigger:
>
>IF OldVal('ActiveUser') = .T. AND ActiveUser = .F.
> REPLACE ActiveUserChg WITH DATETIME()
>ENDIF
>
>I've also tried adding RETURN .T. to the end, but still getting a syntax error
>
>Thoughts?
If it's not broken, fix it until it is.
My Blog