Information générale
Catégorie:
Codage, syntaxe et commandes
Index in your program it just like you would a table. Just know that the index is not persistent from application use to application use. If you index it right on opening the view, the index will remain as long as the view is open. Close the view, and you have to re-create the index when you open it again.
If you set it's NODATAONLOAD property to .T. before when you first open it, then create the index, and then requery it, the indexing time is negligable.
Alan
>I have a view, v_Clients, which is based on an ODBC data connection
>to an MS Access table.
>
>This view is the primary table in a form called Clients. The user
>can pick from a list if clients, and the Client Id is passed into
>the form.
>
>In the Init of the form, I then want to SEEK() the Id in the view so I can display the data.
>
>The problem is that this is a multi instance form. In the first instance
>I could INDEX ON Id TO Id, but then in
>each of the remaining instances, the index file is not accessable.
>
>What I really need is a compound index file for the view.
>
>How do I do this?
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