I have four selection parameters in a screen which is used as selection criteria in my
opnqry.Ideally if all parameters are given the qryslt in opnqry will have all four fields in
the select criteria.
Now i have a scenario where if any of the selection parameter is not given in the screen the
qryslt in opnqry should ignore this field in select criteria and have the remaining.Since
there are 4 parameters there may be a lot of combinations and am slightly confused as to how
to handle this.
To be clear--If a=1,b=2,c=3,d=4 then qryslt will have a,b,c,d if a=1,b=2,c=3 then qryslt
will have a,b,c.Likewise there could be many combinations.
December 29, 2008 12:19 PM
December 29, 2008 7:14 PM