Skip to main content
  • EN

Hi.

Is it possible to execute dynamic SQL in the InlineQuerier ?

I tried something like: SELECT * FROM Merged WHERE @Value(“sql_where”)

but it doesn’t seem to work.

Are there not substitution done in the “SQL Query” window in InlineQuerier ?

Yes, I know it has to be SQLite syntax, and it is.

Cheers.

Hi ​@lifalin2016 Would you be willing to share a screenshot of your SQL Query Editor? 

I believe if the value is available on the the side bar, it should work. Like how I did here with a User Parameter.
 

 

Community Stats

31,949
Posts
121,334
Replies
39,561
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.