• Home
  • Forums
  • FME Form
  • Transformers
  • Can you run a SQLExecutor transformer that takes a string as a parameter and uses it as part of the SQL statement to be executed?
Solved

Can you run a SQLExecutor transformer that takes a string as a parameter and uses it as part of the SQL statement to be executed?

  • 27 July 2021
  • 2 replies
  • 13 views
P
Badge +1

I need to run a sql statement to determine if my workspace should run. If the sql statement returns any records, then I need to terminate the flow. If nothing is returned then it is okay to run the workspace. I would like to pass in a user parameter as a string to be used in the sql statement. Is this possible?

icon

Best answer by redgeographics 27 July 2021, 14:11

View original

2 replies

redgeographics
Rank
Userlevel 5
Badge +25

In short: yes, you can build the query using attribute values, parameters etc.

You should probably look into the NoFeaturesTester to check if nothing comes back too

P
Badge +1

Thank you. I have added the NoFeaturesTester and it seems to be working well.

Reply


Community Stats

28,723
Posts
109,511
Replies
36,559
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.