INSERT Symbol into Database

[brucelim80]

hi Does any one know how to code a SQL statement to allow symbol such as ' to be inserted into the database


I had a code like this

Dim insertprocess As String = "INSERT INTO TrackingDB(workid, username, dept, reportdate, reporttime, " & _
"reinputby, execdate, exectime, systemid, problemcat, descriptiond, problemdetail, handleby, statusid, completeddate, completedtime, resolutiontxt)" & _
"VALUES ('" & lastserialworkid & "','" & reqname & "','" & departname & "','" & reqdate & "','" & reqtime & "','" & inputby & "','" & _
exdate & "','" & extime & "','" & systems & "','" & procat & "','" & prodetails & "','" & prodetailss & "','" & handleby & "','" & status & "','" &
compdat & "','" & comptime & "','" & prores & "')"


However, when i enter a ' and store into one of the variable, it shows syntax error.

Can anyone help me with this>?

Thank you

 

[cjard]

(your sql)

NO NO NO NO NO

We do not write sqls like that for EXACTLY the reason you are now finding.

Can anyone help me with this>?

Please read the PQ link in my signature..