Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing RecordSource of grid on the fly breaks formatti
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01317811
Message ID:
01317814
Views:
12
This message has been marked as the solution to the initial question of the thread.
Jaime,

Besides what Neil has suggested you can also use a "safe-Select" approach for your grid. To do this you establish a cursor with the CREATE CURSOR command to be the record source for your grid. Then when you need to refresh the data you can;
SELECT ... FROM ... INTO CURSOR MyIntermediateCursor
SELECT MyGridCursor
ZAP
APPEND FROM DBF("MyIntermedaiteCursor")
This prevents the grid from losing its setting whenteh cursor is blown away by the SELECT SQL command.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform