topic Re: Problem in select-option in module pool in Application Development and Automation Discussions

Problem in select-option in module pool

Former Member — Wed, 30 Jul 2008 16:17:01 GMT

Hi,

I have 4 fields in my module pool screen, all are select-option and i want to select the data

on basis of these fields.

but condition is that some fields can be blank.

So i have use select query with 'in' option but it does not work when i leave some of the fields blank...

please suggest wat to do.

I will be obliged...

Former Member — Wed, 30 Jul 2008 16:20:02 GMT

check this..

I am involved in this topic, if you have any issues in understanding let me know..

Former Member — Wed, 30 Jul 2008 16:20:22 GMT

one possible option is to use seperate select queries depending on if the select option has data..

IF s_field1[] IS INITIAL.

SELECT ...where ....

ELSE.

SELECT ...where in s_field1.

ENDIF.