Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Table Update
Message
From
29/03/2013 18:29:29
 
 
To
29/03/2013 14:23:23
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01569522
Message ID:
01569552
Views:
36
If you are using tableupdate to update the database, you are probably using a remote view or cursor adapter. Either way, make sure you have your KeyFieldList set properly to the PK of your table. The fields in your KeyFieldList are used to generate the update statement, and if it is set to a different field that all of the records share in common, such as your RecordLive field, then all of the records will be updated to the same value.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform