Use variable in 'SQL Query to CSV File'

[sarnusch]

Good morning,
I am trying to use a variable ({STORE}) with an integer value in 'SQL Query to CSV File' action.

Screenshot 2025-01-28 105217.png (6.96 KiB) Viewed 63249 times

But it always shows an error:

Screenshot 2025-01-28 105131.png (7.09 KiB) Viewed 63249 times

It seems that variables are not working in 'SQL Query to CSV File' action.
The same setup works fine in 'Dataset Loop' action.
Can you please investigate?

[Oleg]

Thank you for the report. It seems this is a bug. We'll fix it
Now you can include RoboTask variables directly in SQL expression
For example:

Code: Select all

select * from addr where locked = {num}

[LucasGaines]

Has the admin fixed the core yet. My screen still shows the error.

[Oleg]

Has the admin fixed the core yet. My screen still shows the error.

This problem has been fixed in version 10.3 (current version)

[David Brown1331]

I’m trying to stick a variable ({STORE}) that has just a number into the SQL Query to CSV File action, but it keeps throwing an error no matter what I do. Weird thing is the exact same variable works fine when I use it in Dataset Loop. Not sure if variables just don’t work in that SQL-to-CSV step or if I’m doing something wrong.

[Oleg]

Send your task to me in private message or publish the text of your task here.
It's hard to say anything without your task