Execute query with parameters is not working as expected

[Palaniyappan (Palaniyappan P)]

Hi @Karun
remove the @ in variable name @reqNo and keep as reqNo
and try to execute with the same query… @Karun
or still not working, kindly have a look at this thread

How to Pass variable to sql execute query?

Ok, delete dlg from parameters and paste into query this: “Select * into " + dlg.ToString + " from Sheet1$ where 1=1” Set dlg value type as GenericValue.

Passing variable to SQL query

Hello guys, I was trying to pass variable (by parameter option) to my SQL query. Blockquote “Select START_DATE, NRB FROM blabla.blablaT_V Where START_DATE between” + date1 + “And ‘07/21/2018’” Blockquote Date1 is a variable passed to SQL query But still get error. I can only pass query with variable as whole as variable (so lets say date2 = “Select START_DATE, NRB FROM blabla.blablaT_V Where START_DATE between ‘07/01/2018’ And ‘07/21/2018’” How can I pass variable to query withou…

Cheers @Karun