Duplicate records being insertedgreenspun.com : LUSENET : DBAzine : One Thread
I'm writing a data layer in VB.net accessing a DB2 databse and for various reasons I can't use SP's. I've written a routine to insert a record into a table but for some reason it always seems to insert 2 reords which are exactly the same apart from the ID field What am I doing wrong?
Cmd.Connection = msConnection Cmd.CommandText = sSql Cmd.CommandType = CommandType.Text
iNoRecords = cmd.ExecuteNonQuery()
-- Louisa Burke (Louisa@sparkdata.co.uk), February 04, 2004