Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update trigger
Message
From
20/03/2000 17:00:26
Bill Emery
MedScribe Information Systems
Sylvania, Ohio, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Update trigger
Miscellaneous
Thread ID:
00348127
Message ID:
00348127
Views:
40
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
Map
View

Click here to load this message in the networking platform