Information générale
Catégorie:
Codage, syntaxe et commandes
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement