Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index on View
Message
From
13/11/1998 14:21:39
 
 
To
13/11/1998 14:05:31
Rebecca Stottlemire
Kansas State Department of Commerce
Topeka, Kansas, United States
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00157416
Message ID:
00157509
Views:
17
>>>I'm trying to set indexes on a view that is browsed in a grid, so that the user can change the order in which they see the data. I have it in the load of the form, and it steps through the code just fine, but the order of the view isn't changed. The session view doesn't show any order set or anything, like nothing has happened. I also repeated the indexing code after the Requery so that I wouldn't loose indexes, but with no luck. Any ideas?
>>>Thanks,
>>>Becky
>>
>>Could you post your code?
>
>Well, the truth of the matter is that I just gave up on the indexing views. I created two separate view, each ordered differently. Then when the user clicks the radio button on screen to change order, I requery the newly requested view and stick it in the grid. This works fine. I don't know why the index didn't work. I had something like:
>SELECT (thisform.cTable)
>INDEX ON lastname+frstname+catcode+skilcode TAG nameorder
>INDEX ON skilcode+catcode+lastname+frstname TAG skilorder (trims on the names)
>SET ORDER TO nameorder
>
>Thanks
>Becky
>
>Lucky me, I'm going to Dallas all next week for COBOL training, yuk!

I don't think that Cobol will help here :).
What can I say? It should work... so something is wrong. Do you really set buffering=3 on views? Do you refresh grid after SET ORDER? If you wouldn't have tags then SET ORDER should bomb your application. May it indicate that you have problems with error handler? (which blanks out all errors?)
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform