Stopping duplicate value insertion

biswa · October 7th, 2009, 03:27 PM

Hi,

I'm in trouble to stop duplicate insertion in the database.
m using VB6.0 and Sql Server 2005.
How can I read the recordset ? is there any datareader , that I can compare whether the new value is already there or not?

Plz help me out.

Thanks.

vb5prgrmr · October 8th, 2009, 04:22 AM

strSQL = "SELECT COUNT(*) AS THECOUNT FROM sometable WHERE FieldOrFields = some criteria that you want to keep unique"
'open rs
If adoRs.Fields("THECOUNT") = 0 Then
'no records so add
Else
'record exists
End If

Good Luck

Old Pedant · October 8th, 2009, 08:40 PM

Or you could just do:

Code:

strSQL = "SELECT 1 FROM sometable WHERE FieldOrFields = some criteria that you want to keep unique"
'open rs
If adoRs.EOF Then
    'no records so add
Else
    'record exists
End If