Skip to Content
avatar image
Former Member

SELECT-OPTION

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 08:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Sep 04, 2008 at 08:50 AM

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

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 08:50 AM

    Hi,

    can you show the code here?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 08:51 AM

    Hi

    Try this

    Provide Search-Help and make that field mandatory

    Thanks

    Vijay.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2008 at 08:52 AM

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

    Add comment
    10|10000 characters needed characters exceeded