Skip to main content
Solved

Inline Querier ROW_NUMBER

  • September 8, 2017
  • 1 reply
  • 23 views
M

I need to use the Inline Querier to perform a row_number, at the moment I am getting the following error (I am using this syntax in SSMS and it is working):

InlineQuerier(InlineQueryFactory): Error preparing database query: near "(": syntax error Unable to execute statement

 

InlineQuerier(InlineQueryFactory): Database was unable to prepare query 'SELECT "Conf Score"

 

,"TOID"

 

,ROW_NUMBER() OVER (PARTITION BY "TOID" ORDER BY "Conf Score" desc)

 

FROM "Sheet1" '.

InlineQueryFactory instance was not properly defined. Consult logfile for details.

 

InlineQuerier(InlineQueryFactory): A fatal error has occurred. Check the logfile above for details

 

A fatal error has occurred. Check the logfile above for details

Best answer by david_r

The InlineQuerier is actually using an internal and temporary SQLite database, it doesn't connect to e.g. SQLServer (I mention this since I see you tagged your post with "sql server").

This means that you can only use SQLite-supported keywords in the InlineQuerier.

If you need to access your backend database, look into the SQLExecutor.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • 8394 replies
  • Best Answer
  • September 8, 2017

The InlineQuerier is actually using an internal and temporary SQLite database, it doesn't connect to e.g. SQLServer (I mention this since I see you tagged your post with "sql server").

This means that you can only use SQLite-supported keywords in the InlineQuerier.

If you need to access your backend database, look into the SQLExecutor.

Community Stats

32,093
Posts
121,876
Replies
39,733
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.