Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving changes from listboxes to target table
Message
From
14/03/1997 12:12:58
 
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00023355
Message ID:
00024264
Views:
41
>Yes, I've done it in similiar way. In screen changes are committed when
>user chose button to save or cancel changes. But is there any easy way
>to save changes into taget table? Right now I'm doing this when saving
>changes:
>scan listbox and compare if every item is in table and append if not
>scan table if every record is in listbox and if not delete it
>It's quit dummy code and I'm looking for more "inteligent" and safer
>way.
>And I don't have set rowsource in my listboxes. I add items by scanning
>table and doing additem().
>Any ideas what would be better?

Well, one idea might be to create a view on the data you want to display and the primary key of the table. Set the RowSource type to Fields, and the RowSource to the list of fields you want displayed. Using the List() array property, you can get information about each row.
- Gino Miceli -
LAN Professionals Inc.
Bayshore, NY
gino@vdot.net
Previous
Reply
Map
View

Click here to load this message in the networking platform