View previous topic :: View next topic
|
Author |
Message |
ovreddy
Active User
Joined: 06 Dec 2004 Posts: 211 Location: Keane Inc., Minneapolis USA.
|
|
|
|
Hi,
Both the queries are same. We can very well use a group variable as parameter for IN. It is equalant of using invidual variables.
Thanks,
Reddy |
|
Back to top |
|
|
Yoyoyo
New User
Joined: 19 Sep 2006 Posts: 26
|
|
|
|
surya_pathaus,
The code is working fine for me.
01 VARS
05 VAR1 - '01'
05 VAR2 - '02'
05 VAR3 - '03'
05 VAR4 - '04'
When I use the query,
Code: |
SELECT *
FROM table
WHERE field1 IN (:VARS)
|
and I get the rows from table where field1 is either '01' or '02' or '03' or '04'!!!
Any more clarifications required? Do lemme know.
yoyoyo!
[/code] |
|
Back to top |
|
|
|