Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter failure
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
CursorAdapter failure
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01056849
Message ID:
01056849
Views:
53
I set-up a Cursor Adapter to test remote viewing a SQL database. I created it just fine and set the correct properties for making the cursor updatable. My initial query drew 12 columns across 4 tables ( basically a view ). I only set the update properties to update certain columns in the bottom children tables.

My question is I set 3 columns in one table, none of which were key columns, to update and I then changed the values in these columns and issued a TableUpdate() without error. Only one of the columns got the update back to the server. If the properties are set correctly can anyone think of a a reason the other two columns did not get the update?
Next
Reply
Map
View

Click here to load this message in the networking platform