[RESOLVED] ODBC SQL Parameters

[Strider]

Hello,

im need to write data to a 3rd party database in which i cannot rename columns etc...
many of the column names contain a "-" in them eg: prod-name

im trying to contruct a parameterised query but im having problems

"INSERT INTO Products (""prod-name"") VALUES (?)"

im using the double quotes so the database will accept the "-"

Dim l_sqlCmd = l_sqlConnection.CreateCommand()
 
l_sqlCmd.Parameters.Add("@prod-name", "My Product")
 
l_sqlCmd.Prepare()
l_sqlCmd.ExecuteNonQuery()

will the parameters accept the parameter name as in the SQL statement there are the double quotes