Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table Buffer mode only updating one record
Message
De
18/02/2002 08:26:44
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
15/02/2002 18:37:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00621002
Message ID:
00621496
Vues:
10
>I’m using a local view with its buffer mode set to 5 “Table”.
>
>After inserting a couple of records I use TableUpdate(.t.) or TableUpdate(1) in order to update all the values to its base table.
>
>Only one records is updated into the base table. By trapping the error I know that I’m getting error 1539 "trigger failed".
>
>I have removed al the relational integrity restriction from the table (there are no other triggers) without success.
>
>I assume that the problem is not exactly a trigger error because I can append the same set of data that which is being inserted into the local view directly into the base table without getting any errors.
>
>¿Could it be the parameter(s) passed to the TableUpdate statement?
>
>Is there anything else I should check?
>
>Thanks in advance for any hints.
>
>Oscar Corte

For debugging purposes, try saving the records one at a time (see GetNextModified()), until you get to the record that can't be saved.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform