UPDATE Deliver
SET TREAT
WHERE TREAT
Question
I'm getting incorrect syntax when running the sqlExecutor. I know the space in the column name is an issue, but i'm not sure of a work around. Wrapping it in brackets and or quotations didn't seem to work.
+18- Contributor
If attribute names have spaces, you have to wrap them in double quotes (same for field or table names with lowercase):
UPDATE "Deliver"
SET "TREAT
WHERE "TREAT
Hope this helps.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.