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