Using Variable numbers in a SQL statement

[tbiceps]

This is SQL statement that I'm using in my code. RptValue, and X represent variable that I want to alter. This SQL statement will not put the constant into the SQL string. If I try to do something similar to the following ('RptValue','X')" then I get the words not values. Does anyone have a clue.


SelClause = "INSERT INTO TBL_Index ([Report ID], [Field ID]) VALUES (RptValue,X)

 

[stix4t2]

If the values are coming off a form then you have to concat the values into the string.

SelClause = "INSERT INTO TBL_Index ([Report ID], [Field ID]) VALUES (" & RptValue & " ," & X & ")"

or use hiphens for a string

SelClause = "INSERT INTO TBL_Index ([Report ID], [Field ID]) VALUES ('RptValue','X')"

 

[PHV]

SelClause = "INSERT INTO TBL_Index ([Report ID], [Field ID]) VALUES [tt]('" & RptValue & "','" & X & "')"[/tt]

If [Report ID] or [Field ID] are defined as numeric in TBL_Index then get rid of the corresponding single quotes.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dRahme]

Hi, How about:

SelClause = "INSERT INTO TBL_Index ([Report ID], [Field ID]) VALUES ('" & RptValue & "' ,'" & X & "')"

Hope that helps

 

[tbiceps]

Thanks everyone!

 

[tbiceps]

Each solution works.