To fix the issue you can do I seem to have a problem with an Update query, I'm trying to use it to update a user's current details in a MS Access database using Delphi XE2. I asked a question previously and got help on the reserved word but now I seem to have another error with this query. The error is : , please use Comma in SQL add lines:
hop of those help? In Excel VBA the string identifier is the " (double quote) character. You do not need to double the single quote characters for them to pass through to the database when enclosed by double quotes. Try this:
strSql = "SELECT * FROM Pricing WHERE Account In ('1234', 'ABCD')"
Update Set - Syntax error (missing operator) in query expression