How to return value from "Execute SQL Script" keyword? about robotframework-database-library HOT 9 CLOSED

from robotframework-database-library.

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

from robotframework-database-library.

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.

from robotframework-database-library.

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.

from robotframework-database-library.

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

from robotframework-database-library.

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

from robotframework-database-library.

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.

from robotframework-database-library.

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

from robotframework-database-library.

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

from robotframework-database-library.