Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change Order of Items in a View
Message
From
24/02/1998 11:06:37
 
 
To
24/02/1998 11:00:56
Jeff Tucker
Mackinac Center For Public Policy
Midland, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00080794
Message ID:
00080797
Views:
30
>I want to use a drop-down box to change the order of items in a view displayed in a grid on a form, but there is no index file for the view and I am not sure how to create one.
>
>I don't see a way to put a parameter in the order by section of the views sql statement.
>
>Is it possible to dynamically do this? If so, how?

You can index a view the same way as you index a table:
Select View1
Index on field1 tag tag1
Index on field2 tag tag2
It will work for Buffering=3 only, i.e. if you have Buffering=5, then use CURSORSETPROP() to reset it temporarily.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform