Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update Conflict - wrong ID #!
Message
 
To
03/06/2001 12:56:20
Paul Williamson
Williamson Enterprises, Inc.
Livingston, Montana, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00514333
Message ID:
00514839
Views:
8
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform