Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating a table from a moverbox
Message
From
24/10/2008 08:31:19
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Updating a table from a moverbox
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01356849
Message ID:
01356849
Views:
79
Got a moverbox where the left side (all items) is populated from a table. The left side contains what has been selected and is populated from a second table that contains the selected items. Then the user can move things between the two sides and when they are done, a cursor of the selected items is created. Populating the lists when the user comes into the form is easy. Moving items between the left and right sides is easy. My problem is how to update the second table that contains the selected items from the cursor. Sounds simple, but the issue is that there could be a set of records already in the table, but now different than the cursor. I need to scan through the cursor and look for a record in the table, then add it if it doesn't exist, but how do I handle ones that are in the table, but are not in the cursor? I guess I could delete everything and just append from the cursor, but that seems sort of heavy-handed.
Next
Reply
Map
View

Click here to load this message in the networking platform