Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
If you actually have a SQL query that returns multiple recordsets (which is completely possible), then you'll need
to use the ADODB.NextRecordset reference to get an object reference to the 2nd,3rd, etc recordsets in your query.
You can then access their fields through standard ADODB object variables.
HTH,
Ed
>I have a recordset based on an SQL query, it includes more than one table. How do I refer to this in code?
>
>In the past I have only used recordsets consiting of one table and so I have used the sytanx
>
>recordsetname!fieldname
>
>but there could be more than one field with the same name in the recordset that I am using now, but from different tables,
>
>I tried
>
>recordsetname!tablename.fieldname and
>recordsetname!tablename!fieldname
>
>but had no luck with either.
>
>Can someone help please?
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