Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>>>>I want to use a drop-down box to change the order of items in a view displayed in a grid on a form, but there is no index file for the view and I am not sure how to create one.
>>>>
>>>>I don't see a way to put a parameter in the order by section of the views sql statement.
>>>>
>>>>Is it possible to dynamically do this? If so, how?
>>>
>>>You can index a view the same way as you index a table:
>>>Select View1
>>>Index on field1 tag tag1
>>>Index on field2 tag tag2
>>>It will work for Buffering=3 only, i.e. if you have Buffering=5, then use CURSORSETPROP() to reset it temporarily.
>>Thank you,
>>
>>When should I index the view? When I load the form, or just before I want to use the index tag?
>
>It entirely depends on how your interface arranged. Just remember that any time you REQUERY() the grid, you will reindex all retrieved records (automatically), so if you retrieve many records it can take additional time.
I tried it using the "just in time" method and I think that will work for now. I understand your comment about the number of records returned.
Thank you
Précédent
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