Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update trigger
Message
 
 
À
20/03/2000 17:00:26
Bill Emery
MedScribe Information Systems
Sylvania, Ohio, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00348127
Message ID:
00348132
Vues:
21
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform