Hi
I'm using a 3rd party software package and doing an insert with 2 columns (neither are identity columns but just numeric) the identity column is columnID (primary key int(4))
the insert statement is
yet i get the following error message, despite the fact I havn't explicity named the identity column in my insert statement ?
any ideas
thanks
error
-----
Cannot insert explicit value for identity column in table 'tblComplaint_ISB' when IDENTITY_INSERT is set to OFF.
I'm using a 3rd party software package and doing an insert with 2 columns (neither are identity columns but just numeric) the identity column is columnID (primary key int(4))
the insert statement is
Code:
ExecQuery_X "CONN_Z","00010::insert into tblComplaint_ISB (crmCallID,CustomerID) Values
(?,?)",array(adNumeric,5,Request("CustID"),adNumeric,5,Request("CustID"))
yet i get the following error message, despite the fact I havn't explicity named the identity column in my insert statement ?
any ideas
thanks
error
-----
Cannot insert explicit value for identity column in table 'tblComplaint_ISB' when IDENTITY_INSERT is set to OFF.