Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Grid Record Order on the fly
Message
 
To
14/07/2009 16:48:58
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01412342
Message ID:
01412408
Views:
92
Hi Randy,

When you change the order of the record source of the grid, you need to refresh the grid. Due to some issues with the grid this is best done while the grid doesn't have the focus. Hence, you need to move the focus of the grid, refresh it, and then move the focus back to the grid. You also should restore the current record number after indexing the data source.

BTW, indexing a cursor should only be done on cursors, never on tables. The index should always be a CDX index, never IDX. IDX file cause a number of problems with VFP's features such as buffering and transactions.
--
Christof
Previous
Reply
Map
View

Click here to load this message in the networking platform