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

But it always shows an error:

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