0

could you give me a syntax for insert into using db2 as the database and vb6 as it's front end?

i am trying to insert a numeric value to my table coming from a host variable in vb6, however, i do not get the proper syntax for it..could you help me?

strSQL2 = "INSERT INTO CPALLIB.loanData(amount) VALUES (" + intAmount + ")"

this gives me = Type Mismatch!

thank you very much..

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by AndreRet
0
strSQL2 = "INSERT INTO CPALLIB.loanData(amount) VALUES ('" + intAmount + "')"

Added the " ' " sign.

0
strSQL2 = "INSERT INTO CPALLIB.loanData(amount) VALUES ('" + intAmount + "')"

Added the " ' " sign.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.