sqlexception error on executenonquery

[basbrian]

hi, still trying to figure out vb . this code was working and then I added an insert trigger on the table in this qyuery. now I get an Sqlexception was unhandled error - subquery returned more than 1 row. how do I fix this???

Thanks

Dim cninsert As New SqlConnection(connectionString)
Dim sqlinsert As String = "insert coffsdelegation_position (pos_ref, code1, code2, code3,del_code) values ('" & cpos & "', " & c1 & ", " & c2 & ", " & c3 & ", '" & cdel & "')"
                
Dim cmd As New SqlCommand(sqlinsert, cninsert)
Dim i As Integer = 0
cninsert.Open()
i = cmd.ExecuteNonQuery()

 

[basbrian]

don't worry about this one, found the problem!

I/O error - idiot operator