Hello every one.
i am trying to catch duplicate values from a data. in the picture when i want to add new record, then if the record already exists then go to that record and fill all the boxes, then i will press the update button,but if not, then add new value. field is indexed.
![Capture.JPG]
so how to code that? i need it very much.
hefaz
3
Hanif Hefaz
Recommended Answers
Jump to PostYou shouldn't allow duplicate records in your database. To prevent this use a unique or primary key to avoid this. Anyway, here is a possible solution at stackoverflow:
http://stackoverflow.com/questions/1840782/how-to-find-duplicates-in-recordset-using-vb6
All 2 Replies
Minimalist
96
Posting Pro
You shouldn't allow duplicate records in your database. To prevent this use a unique or primary key to avoid this. Anyway, here is a possible solution at stackoverflow:
http://stackoverflow.com/questions/1840782/how-to-find-duplicates-in-recordset-using-vb6
hefaz
3
Hanif Hefaz
i use it because, i want to catch duplicate records and pass its values to textboxes for update.
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.