SELECT-OPTION

[Former Member]

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

[Former Member]

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

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

[Former Member]

Hi,

can you show the code here?

[Former Member]

Hi

Try this

Provide Search-Help and make that field mandatory

Thanks

Vijay.

[Former Member]

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

[Former Member]

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

[former_member188685]

>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.