topic RE: OLEDB Syntax Error in Product Forum

OLEDB Syntax Error

PrajjwalRai — Tue, 21 Apr 2020 17:16:00 GMT

Hi,

I am trying to fetch the data into collection using oledb, into parts. For that, I am using the following query

SELECT * FROM [Sheet1$] LIMIT 10000 OFFSET 0

But I am getting Internal Error: Syntax error in FROM clause.

Can someone point out the mistake?

------------------------------
Prajjwal Rai
Application Engineer
Schneider Electric Private Limited
------------------------------

RE: OLEDB Syntax Error

lookman — Wed, 22 Apr 2020 14:26:00 GMT

The OFFSET parm is not valid Prajjwal. Remove it and the select should work fine.

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

RE: OLEDB Syntax Error

PrajjwalRai — Wed, 22 Apr 2020 16:33:00 GMT

Hi Jack,

Can you tell me why it it not valid? Also, I tried with only LIMIT, that is also throwing the same error. Can you please help me?

------------------------------
Prajjwal Rai
Application Engineer
Schneider Electric Private Limited
------------------------------

RE: OLEDB Syntax Error

lookman — Wed, 22 Apr 2020 17:42:00 GMT

Hi Prajjwal.

I'm not an OLEDB SQL guy so I don't know precisely why this does not work.

It seems that select * and LIMIT do not work. If you specify the columns, you can use LIMIT.

When I first responded, I had a test process already set up so I simply added LIMIT and OFFSET, but I had the columns listed. I found that OFFSET failed whereas LIMIT worked, so I said remove OFFSET.

I just tested again with * instead of columns and LIMIT and found it did not work.

Consequently, you should list your columns and use LIMIT. Listing columns is a best practice anyway.

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------