Hi,

Please i need a code in vb6 to compare record stored in databse one after the other to check for the occurence of duplicate record .

1. The check will be the first record compare with other records
2. The check will be the second record compare with other records
.
.
.
.
.
.
.
untill last comparison
As duplicate is found it stored it in another table

Thanks

so what problem are you having?

Your not sure of the logic?
Your not sure how to connect to the database?

Can you provide more details,

i can connect to the database the problem i have,is the flow and how to even start

Hi
Do u want to compare record ( all the fields ) or a single field ? If a single record u can use selection sort approach even for multiple records too.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.