Hello All
I have a query that returns values. Those values are then used in an insert query. The problem seems to be that some of the values returned are strings with "()" included. Im getting 3075 missing operator listing the string as the issue.
Here is the insert query
strSQL = "INSERT INTO StaffCode ( CodeID, ServiceItemCode, ServiceItemDescription, SSSID ) SELECT " + CStr(rst.Fields("CodeID")) + "," + rst.Fields("ServiceItemCode") + "," + rst.Fields("ServiceItemDescription") + "," + CStr(iSSSID) + ";"
What do I do to the ServiceItemDescription to get the string inserted?
Thanks in advance
I have a query that returns values. Those values are then used in an insert query. The problem seems to be that some of the values returned are strings with "()" included. Im getting 3075 missing operator listing the string as the issue.
Here is the insert query
strSQL = "INSERT INTO StaffCode ( CodeID, ServiceItemCode, ServiceItemDescription, SSSID ) SELECT " + CStr(rst.Fields("CodeID")) + "," + rst.Fields("ServiceItemCode") + "," + rst.Fields("ServiceItemDescription") + "," + CStr(iSSSID) + ";"
What do I do to the ServiceItemDescription to get the string inserted?
Thanks in advance