Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Searching a view
Message
From
04/08/1998 15:21:33
 
 
To
04/08/1998 15:14:43
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00123887
Message ID:
00123897
Views:
15
>>I was trying to search a view and got an error because the search class I was using couldn't find an 'order'. It was assuming that I had done a SET ORDER TO on a table. That made me realize the view itself didn't have an order, just the underlying tables. I was sort of assuming I could search the view based on the TAGS of those table(s), but since the tables are in different work areas that doesn't seem likely. Is that correct, and do I actually have to create a temporary INDEX ON 'blah' so I can do a search in the view.
>>
>>Or am I overlooking an easier way to accomplish the same thing?
>>
>>Thanks in advance for the help.
>>
>>Sylvia
>
>You can apply INDEX ON ... command and create temporary tag(s) for view (buffering property should be set to 3).

Thanks Edward -

Can you also tell me whether this is efficient - i.e. is it relatively fast to create these kind of indexes each time (I usually think of indexing as a rather slow process) I want to search through my view? I'm asking because I didn't know if my approach on this needed to be revised?

Sylvia
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform