topic SELECT-OPTION in Application Development and Automation Discussions

SELECT-OPTION

Former Member — Thu, 04 Sep 2008 08:47:27 GMT

I have a select-option on a selection screen, which is based on a table field - vkpf-blart

now if the user doesnt select this select-option, selection should be made on all these values

but the problem is that all other values apart from those in the table are being taken

is there any way i can stop that

Re: SELECT-OPTION

Former Member — Thu, 04 Sep 2008 08:50:24 GMT

Could you post the select query which u used for fetching from vkpf

Edited by: Thyagu on Sep 4, 2008 10:51 AM

Re: SELECT-OPTION

Former Member — Thu, 04 Sep 2008 08:50:52 GMT

Hi,

can you show the code here?

Re: SELECT-OPTION

Former Member — Thu, 04 Sep 2008 08:51:10 GMT

Try this

Provide Search-Help and make that field mandatory

Thanks

Vijay.

Re: SELECT-OPTION

Former Member — Thu, 04 Sep 2008 08:51:34 GMT

Sia

Write two queries... If use makes some selection in the field, then go for SELECT query having the selection field in the WHERE clause....

If user doesn't make any selection then go for SELECT query having no condition in where clause for that field..

Thanks

Amol Lohade

Re: SELECT-OPTION

Former Member — Thu, 04 Sep 2008 08:52:50 GMT

>but the problem is that all other values apart from those in the >table are being taken

show your select first.?

do you have any other selection criteria apart from the blart.

if you don't enter any thing then it considers all the values that is the nature of the select option. if you don't want that then you need to use the parameter.

Re: SELECT-OPTION

Former Member — Thu, 04 Sep 2008 09:03:45 GMT

You should try using this

IF sel_opt[] IS INITIAL .

SELECT query without considering select option in where condition.

ELSE.

SELECT query considering select option in where condition..

ENDIF.

Thanks & Regards,

Vivek Gaur