RoboTask forum

Posted: **Tue Jan 28, 2025 10:57 am**

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 13392 times

But it always shows an error:

: Screenshot 2025-01-28 105131.png (7.09 KiB) Viewed 13392 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?

Posted: **Tue Jan 28, 2025 11:30 am**

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}

Posted: **Thu Apr 03, 2025 4:40 am**

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

Posted: **Thu Apr 03, 2025 1:34 pm**

LucasGaines wrote: ↑Thu Apr 03, 2025 4:40 am Has the admin fixed the core yet. My screen still shows the error.

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

RoboTask forum

Use variable in 'SQL Query to CSV File'

Use variable in 'SQL Query to CSV File'

Re: Use variable in 'SQL Query to CSV File'

Re: Use variable in 'SQL Query to CSV File'

Re: Use variable in 'SQL Query to CSV File'