problem executing in command-line interface using variables

[cristian.jesus]

i have a problem executing a query in command-line interface using variables, the instruction that i use is:
"C:\Program Files\QueryReporter\QueryReporter.exe" userid=myusr/mypw@mydb sql="select * from mytable WHERE some_column=&my_value" &my_value="some_value" csv="x:\test.csv" quit

i've tried this using the user guide. it shows a message in command-line that says:
"my_value" is not recognized as an internal or external command, program or batch file

 

[Marco Kalter]

You will need to specify the complete variable expression in double quotes. Instead of:

&my_value="some_value"

specify:

"&my_value=some_value"

 

[uros.r.d]

problem executing a query in command-line interface using variables, the instruction that i use is:

"C:\Program Files\QueryReporter\QueryReporter.exe" userid=zk_kontrole/testb@GU-TESTB exec="01-StatistikeRS-poSifriNapake.rep" "&izvedba=37" csv="01-StatistikeRS-poSifriNapake.csv" hide quit

And i still the windows for entering variable pops up!
I don't wont quit execution without interupts to execute as batch command file.

 

[Marco Kalter]

The order of the parameters is significant: you must assign the variable value before executing the report.

 

[uros.r.d]

I tried some variations but not the case you suggested.
Thanks. It works.