Skip to main content
  • EN
  • 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?

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?

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

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

Reply


Community Stats

30,176
Posts
114,544
Replies
37,837
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.