Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Save/Remove/Restore an object??
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00671677
Message ID:
00671812
Views:
14
Victor,

Using the Requery() function on a veiw will not cause problems for girds and for combos and lists you need to call the object's requery method after you requery the view. Issuing the SELECT command again will cause problems for a gird, but Requery("MyView") will not. If you are issuing the select again you can;
Thisform.Grid.Recordsource = ""
* Do your select again
Thisform.Grid RecordSource = "TheViewName"
This will prevent the grid from losing its mind.

For combos and lists you don;t need anything fancy except that you MUST call the control's Requery method after you repopulate the view. Combos and list hold an internal list of items that ios filled on load and on the Requery method being executed. Simply changing the rowsource's contents does not cause the control to refill its internal list.
SELECT ...
Thisform.Combo1.Requery()
You don't even need to hide these controls.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform