Information générale
Catégorie:
Codage, syntaxe et commandes
>>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
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