General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only