Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Thanks,
I guess I'll try looping through one recordset and looking up records in another recordset. Unfortunately there are a few recordsets needed in the joins so it will be a bit of work.
I did initially have a temp table in the database and filled this with data. This works, but it does mean that the Access database grows until a compact is done. I would like to move away from Access as the database and I will in the future, but I have no choice in the matter at the moment.
Pete
>Hi Peter.
>
>There's no way to do this, at least that I've come across. I've been faced with similar situations and I have gotten the data I need from the second table, then added the table's fields to the memory-only ADO recordset, then looped through the two recordsets to add the appropriate data.
>
>This requires a design that includes as little data as possible being returned from the data source, of course...
>
>I have also seem folks create temp tables and dump the memory-only rs into the table, and *then* execute a select. And then, of course, clean everything up. Pretty inelegant, but it works.
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