CarlPritchard
asked on
Query a disconnected recordset
I have a using disconnected recordset in an application some of which are not tied into a database (this is because in the scenario I have they are much faster than the alternatives).
So far I have been able to work very well using Filter and Sort only and this has been considerably faster than the previous code which used a large collection of classes to store data.
I have come up against a particular point where ideally I would want to run a query against this disconnected recordset in order to get a Distinct list from one of the fields.
If the query was against a database it would along the lines of:
SELECT DISTINCT MyField1 FROM MyTable1 ORDER BY MyField1 ASC
Is there any way I can do this against my disconnected recordset. I can use other techniques if necessary (by checking each record and transfering that field if it doesn't exist in the second disconnected recordset) but this will probably be slower than something that is query based.
I am using VBA so using ADO is considerably faster than anything I can develop in VBA.
So far I have been able to work very well using Filter and Sort only and this has been considerably faster than the previous code which used a large collection of classes to store data.
I have come up against a particular point where ideally I would want to run a query against this disconnected recordset in order to get a Distinct list from one of the fields.
If the query was against a database it would along the lines of:
SELECT DISTINCT MyField1 FROM MyTable1 ORDER BY MyField1 ASC
Is there any way I can do this against my disconnected recordset. I can use other techniques if necessary (by checking each record and transfering that field if it doesn't exist in the second disconnected recordset) but this will probably be slower than something that is query based.
I am using VBA so using ADO is considerably faster than anything I can develop in VBA.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.