You are in effect firing the trigger again because your trigger is doing an update. use the Field Validation Rule instead. An Update trigger can not be used to update any field values. An analogy would be something like an endless loop.
>I’m using Windows NT4 and VFP 5. I have a file named testfile.dbf in a database named testtrigger.dbc. testfile.dbf has 3 fields, A, B and C all of type Numeric with a length of 5.0. The value for C is A times B (A*B), so I attached an update trigger at the record level to replace C with A*B. I’ve got the data file open exclusively and am sitting on record one. When I type the command:
>
>Replace a with 10
>
>In the command window the update trigger fires just as it should, then errors out at the line containing the REPLACE verb. The error message I get is Error number 111; Cannot update the cursor. I’m passing a set of parameters to the function, and they seem to be coming over OK. Can someone please explain what I’m doing wrong, or point me in the right direction? Thanks!
>
>Bill
Mark McCasland
Midlothian, TX USA