Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Make ordering in grid
Message
 
To
12/12/2003 10:46:45
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00858599
Message ID:
00858605
Views:
32
>Hi All,
>
>I had 3 Index order for a single table(ItemNo.,DocumentNumber,EpiryDate)
>
>I used set filter command in grid, what I need is how can I make Order by EpiryDate in grid ?
>
>Thanks For Your Time.

You can use SET ORDER TO [appropriate index tag here] and refresh the grid. See help for SET ORDER command

Also, filters on big tables can slow down your processing significantly. Depending on your situation, as an alternative you might try to use SQL statement as a recordsource for the grid. That may give you both filtering and ordering.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform