Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to setup a trigger?
Message
From
24/01/2006 18:07:13
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01089925
Message ID:
01089941
Views:
12
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform