David -
Thanks for your help on this. Now that I can fire a trigger, do you know how to identify the field that caused the trigger to fire? AS in:
cMessage = alias() + '.' + thefield + ' was changed.'
and of course the next step will be to get the before and after values.
Thanks
>Don,
>
>Try:
>
>
>storehistory()
>
>
>>I've created a stored procedure in the database as
>>
>>
>>procedure storehistory
>>wait window 'record changed'
>>
>>
>>then modi stru thetable
>>and add
>>storehistory
>>in the update trigger.
>>
>>browse the table and modify a value produces an error to the effect that the variable storehistory is not found. What am I doing wrong?