Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter Update Problem
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01016803
Message ID:
01016873
Views:
14
>I created a join with a cursor adapter. I then changed values on the first
>record, on fields from both tables, and when I did a TABLEUPDATE(), the field
>from the Left table was changed for ALL records, and the Right table was ok.
>
>Anyone know what I'm doing wrong?
>
>Thanks

What exactly do you want updated? The "right" table only? The key to this is to imagine what kind of SQL VFP is going to generate for you for the update based on the values of the following properties: Tables, KeyFieldList, UpdatableFieldList and UpdateNameList. If you do not want records in the "Left" table updated, leave that information out of those properties. If my assumptions are wrong, just post the values for those properties and what/how you want your data updated.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform