Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update Trigger
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00315733
Message ID:
00315753
Vues:
17
Yup! Thanks. Funny thing is when I modified the structure of the table to put the rule in, I was getting the same error. When I unchecked the option to compare the rule against existing data when exiting the MODIFY STRUCTURE, I did not get the error. From then on the rule worked. Now there's a GOTCHA! [VFP6 SP3]

>Hi Mark,
>
>I believe you can do this from the Record "Rule" validation.
>
>
>>I have several tables where I store a check sum value to a field based on values of other fields in the same table. I am trying to use the Update trigger on these tables to replace this CheckSum field with an integer value. Whenver I do, I get a Can not update the cursor error when I issue a replace ChkSum with lnChkSum command in the SP trigger code. I can kind of understand this in that this is a record level data verification trigger. Is there any way I can use a trigger to replace a field value in the record being updated and validated by the update trigger?
>>
>>TIA!
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform