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:10:49
Jeff Tucker
Mackinac Center For Public Policy
Midland, Michigan, United States
 
 
To
24/02/1998 11:06:37
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00080794
Message ID:
00080799
Views:
26
>>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.
Thank you,

When should I index the view? When I load the form, or just before I want to use the index tag?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform