Skip to main content
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.

  • August 1, 2019
  • 1 reply
  • 2 views

spud
Participant
Forum|alt.badge.img

UPDATE Deliver

 

SET TREAT

 

WHERE TREAT
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

erik_jan
Contributor
Forum|alt.badge.img+22
  • Contributor
  • August 1, 2019

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings