Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update Conflict - wrong ID #!
Message
 
À
03/06/2001 12:56:20
Paul Williamson
Williamson Enterprises, Inc.
Livingston, Montana, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00514333
Message ID:
00514839
Vues:
9
I have researched the view and found that the ID Number field that VFP is trying to update is an ID number from a different view on a different table!! That ID number does NOT exist in the view I am trying to update, yet I get that error (which is a good thing I think because it is the wrong ID number).

If you are getting the primary key value from sql*server and using the @@ command to retrieve it, beware that if you have insert/update triggers that create records in other tables (like audit tracking) then this could give you the those table's ID values instead (ok -- I only read about this on UT, I am still setting the primary key from a last used id table)

Kevin
Kevin Emmrich
www.jkt9000.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform