Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Searching a view
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00123887
Message ID:
00123902
Views:
19
Thanks Ken -

My view is actually a list of people who have registered for a conference (out of all the names which exist in my people table), so it already is filtered somewhat. But after I retrieve the list of all people who have registered for the conference, I wanted to let the user look for the one they want and that is why I thought I needed to index my view based on (e.g.) last name + first name. But I was somewhat concerned about this process (i.e. the indexing) taking too long if it happens every time a user wants to search.

Sylvia

>Yes, if you want to use seek or find on the view you will need to build an index on the fly. However, the real key to using views effectively is that you want to retrieve only the records you need to work with and keep the cursor as small as possible. For example, instead of opening a view that contains all the records in the file and narrowing it down based on the user's input, you would get the key beforehand, then open (or requery) the view.
>
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform