topic OLEDB - SQL Query - Too many characters - Data Item in Product Forum

OLEDB - SQL Query - Too many characters - Data Item

JonathanHolstin — Fri, 13 Dec 2019 22:12:00 GMT

Hello,
I need to run a large sql statement. Currently the only way I know how to pass sql into the Data - OLEDB (Get Collection) is by using a data item with the sql statement. That limits you to a small number of characters (255?). Does anyone know how to pass a large sql statement into the Get Collection action?

Thanks!
Jon

------------------------------
Jonathan Holstine
Systems Accountant
Interior Business Center
America/Denver
------------------------------

RE: OLEDB - SQL Query - Too many characters - Data Item

vivek.kumar.goel — Mon, 16 Dec 2019 03:15:00 GMT

There is no such limitation.
Can you post the SQL Please?

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
https://www.rpatools.com/
"If you like this post, please press the "Recommend" Button.
------------------------------

RE: OLEDB - SQL Query - Too many characters - Data Item

EdGarabedian1 — Mon, 16 Dec 2019 12:22:00 GMT

Hi Jonathan,
I recently ran into this as well working with OLEDB. One method would be to use multiple data items for sections and then concatenate in a final data item, i.e. [sql pt1] & [sql pt2]. I created variables for the base sql, where clause, and fields I would select and then concatenated together for complete sql statement. Another method would be to store the query in an external text file, load that file when needed and pass to object. You could do this with the pre-built Utility-File Management VBO or you could use a code stage, example here: http://portal.blueprism.com/customer-support/support-center#/path/1158159412
Thanks,
Ed

------------------------------
Ed Garabedian
Sr. Solutions Consultant
Blue Prism
------------------------------