how to compare two recordset object

[hspc]

you will use 2 nested loops !!!
nothing like rs.compare():rolleyes:

[mustusoft]

hi!! Friends

I am having two databases with the same no. of tables and tables having the same structure....with almost the same data in it

the two databases are placed on two different machines

Using visual basic...

I create a recordset from a table of the first database
and a recordset from the table of the second database

Now the problem is ..I want to compare the two recordsets
i.e. the data in the two recordsets are exactly the same or not..
without using the for loop in just one statement...
Is there a way....or any other way to go about....


Thanx for the help

Regards
Mustafa

[mustusoft]

no way to compare two objects in this case a recordset object

What I exactly want to do is compare data in two tables for variance......

and the logic i want to follow is that

check a group of records at a time

e.g.
If total 50,000 records
take the first 25000 records from both the tables and compare
if they have no variance
then take the second 25000 records.....if there is variance
then from that 25000 records take the first 12500 records and then check for variance....

In this way i have to go thru less no of looping...

but this will be possible if only i can compare chunks at a go....

thanx for the help

regards
Mustafa