vb and access

banbutcher

is there any way of checkin for duplicate records in vb when i try add another one?

i need it: if a song already exists then msgbox else DBMusic.Recordset.Update
but im not sure how to do it!
any help will not go unnoticed!!
Cheers

Trizo

You could have a select statement checking for the entry in the datatbase, if the number of rows returned = 0 then it is'nt a duplicate anything else means its already there.

causal

banbutcher wrote:

is there any way of checkin for duplicate records in vb when i try add another one?

i need it: if a song already exists then msgbox else DBMusic.Recordset.Update
but im not sure how to do it!
any help will not go unnoticed!!
Cheers

I'm a bit rusty at VB and Access, but:

How are you specifying that a song already exists
- is it based on the song 'name', or some code?

Whatever it is - make that column unique within it's table, in your database definition.

In your VB code - update the database with the song details - catch any error thrown (record already exists, whatever) by the database in your VB code and then open your message box if necessary.

Basically - let the database handle checking whether the song is already there.

causal

jessy

yep agree with Trizo, a simple SQL query will do it.

Kernel32

I agree with casual. Keep the data integrity rules in the database. Databases out live application front ends and having an index is the most efficent way of handling the problem.