Insert statement using variables

[ikim2000]

I get an error when I execute the below INSERT statement. Cost and Price are money data types:

sqlText = "Insert Into tblProduct(ID,Cost,Price) values ('" & vProductID &"',vCost,vPrice)"

Is my syntax correct for vCost and vPrice?
---------------------------------------------------------
When I try the statement below it works:

sqlText = "Insert Into tblProduct(ID,Cost,Price) values ('" & vProductID &"',15,25)"

Thanks,
ike

 

[sunila7]

Hi,

Try this.....

sqlText = "Insert Into tblProduct(ID,Cost,Price) values ('" & vProductID & "'," & vCost & "," & vPrice & &quot"

Sunil

 

[ikim2000]

Thanks, it worked.
Any explanation as to why "& cost &" vs. vCost ?

 

[sunila7]

Hi,

VCost and vPrice r variabels used to form the SQL, so they have to be concatenated with the SQL string so that a Proper SQL String is formed.

Sunil