ADO Insert problem. -- vb.net data

vinu
12/17/2004 2:15:03 AM

We are having a strage problem wwhen we use recordset object for insert , it
insert 3 more extra rows..

SQL :

SET NOCOUNT ON;INSERT INTO F_BANK_STATEMENTS (STATEMENTDATE,
STARTINGBALANCE, ENDINGBALANCE)
VALUES ( '16 December 2004',3.00, 3.00);SELECT @@IDENTITY AS BANKID;SET
NOCOUNT OFF

Function OpenRs(RecSet, iSQL)
'response.write iSQL
Set RecSet = Server.CreateObject("ADODB.Recordset")
RecSet.Open iSQL, Conn, 0, 1
End Function

what could be the problem

evan b
12/17/2004 8:55:13 PM

er you dont actually open a recordset to run an insert

just do Conn.execute iSql

[quoted text, click to view]

vb.net data : ADO Insert problem.