topic Re: OLEDB Query Syntax error in Product Forum

OLEDB Query Syntax error

KeerthanaJegann — Tue, 22 Jun 2021 23:11:57 GMT

I just used a query for SELECT [first_name], [last_name], RANK() OVER ( PARTITION BY [department_id] ORDER BY [salary]) [salary_rank] FROM [employees$] - but when i run this query using OLEDB VBO- i get this error -

": Syntax error (missing operator) in query expression 'RANK() OVER ( PARTITION BY [department_id] ORDER BY [salary]) [salary_rank]"

Not sure, what is the syntax error. Can someone please help me with it.

Re: OLEDB Query Syntax error

mkumar407 — Wed, 23 Jun 2021 03:53:46 GMT

Hey,

Can you check SQL compatible syntax for your database. If connecting to Access it might be ANSI-92 and RANK is not supported in ANSI-92.

Re: OLEDB Query Syntax error

KeerthanaJegann — Wed, 23 Jun 2021 22:59:05 GMT

Hello,

Thanks for the reply. Yes I am connecting to Database engine. How can I check the SQL compatible syntax? And I am not sure what are the queries I could really use using OLEDB VBO. Do we have any documentation for it? Thanks!

Re: OLEDB Query Syntax error

EmersonF — Thu, 24 Jun 2021 00:24:56 GMT

@KeerthanaJegan1,
See if it helps you in any way
http://community.blueprism.com/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=56f3f77f-6c92-4a75-9e66-0b0ed2f6e054