>>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!
>
>Doug's right, you have to use the REcord Validation Rule. THis is also the only way to implement a timestamp field in VFP.
>
>If you think about it, it would be bad news to have an update trigger modify a field. Can you say infinite loop?
Yeah, I got a case of tunnel vision. I got it in my head that every time the record is updated, I want a specific field updated every time, so I locked in on the update trigger.
Mark McCasland
Midlothian, TX USA