Hi
i got a error while insert a data. if same query i run in ms access its working row append.
but code through means its show error. pls help us.
Coding
Public db As New ADODB.Connection
.....
.....
vquery1 = "INSERT INTO DCD (PROD,TYPE,MONTH,AGEINGBRACKET,OCREF,PARTYNAME,INVQTY,FREIGHT,CFEXPENSES,COMMISSION) VALUES ('" & VPROD & "','" & VTYPE & "','" & VMONTH & "','" & VAGEINGBRACKET & "','" & VOCREF & "','" & VPARTYNAME & "'," & VINVQTY & "," & vpassvalue & ")"
db.Execute vquery1
query with values:
INSERT INTO DCD (PROD,TYPE,MONTH,AGEINGBRACKET,OCREF,PARTYNAME,INVQTY,FREIGHT,CFEXPENSES,COMMISSION) VALUES ('AV','1.BOOKED','2011 10 OCTOBER','6 - 9 Months','1/A/01','HAJI NOOR',20.344,0,0,0)
advanced thanks
i got a error while insert a data. if same query i run in ms access its working row append.
but code through means its show error. pls help us.
Coding
Public db As New ADODB.Connection
.....
.....
vquery1 = "INSERT INTO DCD (PROD,TYPE,MONTH,AGEINGBRACKET,OCREF,PARTYNAME,INVQTY,FREIGHT,CFEXPENSES,COMMISSION) VALUES ('" & VPROD & "','" & VTYPE & "','" & VMONTH & "','" & VAGEINGBRACKET & "','" & VOCREF & "','" & VPARTYNAME & "'," & VINVQTY & "," & vpassvalue & ")"
db.Execute vquery1
query with values:
INSERT INTO DCD (PROD,TYPE,MONTH,AGEINGBRACKET,OCREF,PARTYNAME,INVQTY,FREIGHT,CFEXPENSES,COMMISSION) VALUES ('AV','1.BOOKED','2011 10 OCTOBER','6 - 9 Months','1/A/01','HAJI NOOR',20.344,0,0,0)
advanced thanks