By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,098 Members | 1,950 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,098 IT Pros & Developers. It's quick & easy.

Compare two records in the same recordset

topher23
Expert 100+
P: 234
So I'm working on this new project that involves comparing the machine settings for a product against the machine settings for the next product run to see which machine settings need to be changed, then allotting an amount of time for the changeover based on which machine settings are different.

What I'd like to know is: is there a way to compare these two records in the same recordset against each other directly, without generating a second recordset or using array variables? Due to the complexity involved in the data, the routine already has 3 recordsets and several variables, including at least one array. If it's at all possible, I'd like to avoid creating more memory-hogs unnecessarily.
Apr 5 '10 #1

✓ answered by ADezii

You can 'Clone' the Recordset which is not the same, and does not carry the same overhead, as creating an additional Recordset.

Share this Question
Share on Google+
4 Replies


ADezii
Expert 5K+
P: 8,638
You can 'Clone' the Recordset which is not the same, and does not carry the same overhead, as creating an additional Recordset.
Apr 5 '10 #2

topher23
Expert 100+
P: 234
Thanks Adezii! Since I've only ever needed to clone a form's recordset, I didn't even think about cloning a code-created recordset. Good tip!
Apr 5 '10 #3

ADezii
Expert 5K+
P: 8,638
Let us know how it works out.
Apr 6 '10 #4

topher23
Expert 100+
P: 234
Works great, no problems. I like the solution.
Apr 6 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.