How to pass string array in execute query at a time?

Help Studio
1

Hello Everyone,

I’m able to pass the string array in execute query but one by one which takes a long time. I’m trying to provide all the value in an array at a time just like we do in SQL but i’m not getting success. Can anyone help me out from this situation.

Thanks,
Harsh

2

@Harsh95 What operation are you performing in Execute Query ? Select ? Can you tell me How you need the Query to be ?

3

@supermanPunch Yes I’m performing Select. For ex: select * from table where column1 in(here is have to pass all the elements present in the array).

4

@Harsh95 I guess you might need to join the array variable using the delimiter “,” and use that value in Query

5

Thanks @supermanPunch Let me try this.

6

@supermanPunch It’s working brother. Thanks for the help.

1 Like