• Home
  • Forums
  • FME Form
  • Transformers
  • 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.
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.

  • 1 August 2019
  • 1 reply
  • 0 views
S

UPDATE Deliver

 

SET TREAT

 

WHERE TREAT

1 reply

erik_jan
Rank
Userlevel 2
Badge +16

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


Community Stats

28,731
Posts
109,530
Replies
36,565
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.