Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update Conflict
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00296827
Message ID:
00296938
Vues:
16
>I have a view where some new records have been added. I then scan through the view and issue a replace on a record that was just added and I get this error message "Update Conflict" when I hit the endscan to move to the next record in the view.
>
>How can I avoid this?

Are you using row or table buffering? I have had a similar problem [my own fault] where I added a record to a view with no KeyID [the KeyID is generated when written back to the source table where I have defaulted the KeyId to be GetPrimaryKey("TableName")]. So while I am working with the view, any new records have a KeyID of zero and they still do not exist in the source table. If you use record buffering, you could have triggered an update that wrote the new records to the source table. The source table now has these new records but with a legitimate KeyID. However, the KeyID in the view is still zero. They will remain zero until you requery() which can be bad if you have uncommitted changes.

What is the backend? VFP? Oracle? SQL Server?
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform