• EN
Solved

Inline Querier ROW_NUMBER

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

icon

Best answer by david_r 8 September 2017, 17:16

View original

1 reply

david_r
Rank
Userlevel 5

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


Community Stats

28,818
Posts
109,853
Replies
36,633
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.