Skip to main content
Solved

Inline Querier ROW_NUMBER

  • September 8, 2017
  • 1 reply
  • 15 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.

View original
Did this help you find an answer to your question?

1 reply

david_r
Evangelist
  • david_rEvangelist
  • 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.

Reply


Helpful Members This Week

Community Stats

30,886
Posts
117,074
Replies
38,698
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.