ADO Recordsets

I am being passed a disconnected ADO recordset which I am navigating through.  If a particular record meets certain criteria I want to pass only this record onto another function for processing.  How do I do it?  I don't want to pass each individual field as a parameter as there are 20+ fields.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I assume you don't want to reconnect to issue another SQL query, or you wouldn't have used a disconnected recordset.
Have you considered using the .GetString or .Getrows methods of the ADO recordset? These allow you to retrieve only specific rows into a string or variant array.
Or you could use the SHAPE command to pack certain child rows into a field of a parent recordset. Then you can pass on the field, and the client can unpack it by assigning the field to a recordset. Although it isn't extremely hard, it takes some abstract thinking though to master the SHAPE SQL syntax.
Also, in ADO 2.5 Microsoft added a Record object. I haven't used it myself yet, but the MSDN provides some basic examples explaining it's use.

I hope I've been of some assistance.

Michel Rutten

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ShaleyAuthor Commented:

After I posted this question I stumbled upon GetRows and have started implementing it.  You have confirmed my thinking.

Thanks for your time.


It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.