Member Avatar for xuexue

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
  • 121 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for AndreRet 
strSQL2 = "INSERT INTO CPALLIB.loanData(amount) VALUES ('" + intAmount + "')"

Added the " ' " sign.

Member Avatar for AndreRet 
strSQL2 = "INSERT INTO CPALLIB.loanData(amount) VALUES ('" + intAmount + "')"

Added the " ' " sign.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.