Comparison code

[realone]

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

[bushman_222]

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,

[realone]

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

[selvaganapathy]

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.