Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Searching a view
Message
De
04/08/1998 17:45:34
 
 
À
04/08/1998 16:06:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00123887
Message ID:
00123934
Vues:
21
That is excellent advice. I don't know why I couldn't see that...Duh..I need mental floss. Thanks!

>You don't need to build the index on every search. Build the tag(s) once when the view is first opened, and they will remain until you close the view. While the view is still open, you can treat them the same way you do tags on a table.
>
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform