How can pass

Help Studio
, ,
1

how can pass a variable in SQL query
i have a str variable that i want to pass

i am using execute query tried “+variable+” ---- not working

? ----- getting blank (variable passed as parameter)

2

Hi @manoj_verma1

You need to pass the variable as like below

‘“+Yourvar+”’

Regards

3

Hi @manoj_verma1

Try the below query
"Select data From TN Where CN = '" + varClientID + "'"

Regards
Gokul

5

getting blank response

6

Can you show your query screenshot @manoj_verma1

7

Hi @manoj_verma1

Can we see a full query that you re using?

Regards

8

Have a look on the thread @manoj_verma1

Regards
Gokul

1 Like
10

Close the double quotes before (’
Like this
“…_No in ('”+argument+“')”

and try again

Regards
Gokul

11

yes i tried it giving me error string to be end in double quotes

12

Hi @manoj_verma1

If possible can we have a query in editable format here so that we can make changes and provide?

Regards

13

What is the type of argument1?

14

string

15

Okay So can you try this,

String.Format(“…_No in (’{0}’)”,argument)

Hope it will work

Regards
Gokul

16

getting same error string to be in quotes