Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to setup a trigger?
Message
De
24/01/2006 18:07:13
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01089925
Message ID:
01089941
Vues:
13
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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform