How to return value from "Execute SQL Script" keyword?

[keyjm]

I have a very complex SQL join which is outputting a single value. How do I return that value using "Execute SQL Script" keyword ? I am using keyword below

Test Case
Connect to Database
${result} = Execute Sql Script ${EXECDIR}${/}resources${/}cg.sql

Its returning "None"

[jerry57]

What is returned in ${result}? Try adding a Log ${result} after the Execute SQL Script line. Can you send a copy of your sql script? Or an example? Jerry S

…

On 3/1/17 5:56 PM, kunalmalviya wrote: I have a very complex SQL join which is outputting a single value. How do I return that value using "Execute SQL Script" keyword ? I am using keyword below Test Case Connect to Database ${result} = Execute Sql Script ${EXECDIR}${/}resources${/}cg.sql — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#74>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAm11llBlf6YxeyLwW_tcYiZQl8LqmVcks5rhhOqgaJpZM4MQaPt>.

-- http://www.linkedin.com/in/jerryschneider Linux registered user #475536 Ubuntu registered user #28583

[keyjm]

Output is ${result} = None
I also tried with log and can see that it says "None".

Also if I run the same sql script with "Query" keyword it does returns the result and saves in ${result}. Screenshot of my result and example query attached.
Query.txt

[jerry57]

Thanks for the updated info. Do you get the same results if you use "Execute SQL String"? For the moment, can you use the "Query" keyword until this can be resolved as a work around. I ran into similar issues executing stored procedures, which now has it's own keyword.

[keyjm]

Yes, I get the same result when using "Execute SQL String" keyword.

It would be great if the issue with those two keywords can be resolved, of course when you get a chance :). Thanks for help.

[jerry57]

If you have a chance, can you work this and submit a pull request please?

[cool-amy]

Any update on this bug? i ma using "Execute Sql script" Keyword and it is not returning anything , same for

"Execute Sql String". And if i use "query" keyword then i have to put long query with many joins, it it throws me sql error. If some body can fix this issue, that will be great

[jerry57]

Unfortunately the projects I am on right now do not afford me the time to work this. If you can get a pull request submitted, I will try to review and merge right away though.

[jerry57]

The number of rows will be returned by Execute SQL keywords. Data returns will be done only through Query keyword.

[ArtsemNikulin]

Works for me
${script}= get file SQLScripts/SQLQuery_1.sql
${res}= query ${script}