Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
ADO support for indexes
I am a foxpro programmer but new to VB and Access.
I am retrieving an entire table into an ADO record set from an Access 2000 database using the Jet 4.0 engine
through an ADO connection using Visual Basic 6.0.
The underlyig Access table has two indexed fields.
I want to set the index of my record set to one of the underlying indices of the table.
Unfortunately, I cannot get ADO to support indexes.
I have tried setting the RecordSet.CursorLocation to both possible choices: adUseClient and adUseServer.
Neither does any good.
When I check the support of indexes using RecordSet.Supports(adIndex), it returns False.
Is there a way to set an index on a retrieved record set in ADODB?
Any help would be appreciated.
Tony Lin
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