Skip to main content
Question

Is it possible to use WITH RECURSIVE in InlineQuerier? It is not working for me. Thanks for your help!

  • May 27, 2022
  • 2 replies
  • 32 views

fme
Contributor
Forum|alt.badge.img+7
  • Contributor
  • 31 replies

Is it possible to use WITH RECURSIVE in InlineQuerier? It is not working for me. Thanks for your help!

2 replies

ctredinnick
Supporter
Forum|alt.badge.img+19
  • Supporter
  • 225 replies
  • May 29, 2022

Seems like it is. InlineQuerier uses Sqlite, and from the documentation https://www.sqlite.org/lang_with.html the basic example to produce 1000000 numbers works for me in FME (2021.1)


fme
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • 31 replies
  • May 31, 2022

Seems like it is. InlineQuerier uses Sqlite, and from the documentation https://www.sqlite.org/lang_with.html the basic example to produce 1000000 numbers works for me in FME (2021.1)

Thank you!