Avoiding adding duplicate info the your DB

[timcadieux]

Hi folkz, what's the smartest way of checking to see if a value exists in the DB, ignoring it if it exists or adding it if it doesn't?

 

[Sheco]

If every value of the field should be unique then perhaps make it a key...Then you could just attempt to insert it and trap the key collision error when it is non-unique.

You could just query for it before running the insert but that will definately increase load on the db... sometimes this matters a lot more than others... if you have a big fancy dedicated database server that spends all day at 3% load then its not such a big deal...

 

[Kendel]

I'd verify against the db see if the record exists:

"Select filedname from youTable where id = " & NewID

If rs.EOF then
'not exists, do the insert
Else
'exist
End if

 

[timcadieux]

thx!