topic Re: WITHOUT INPUT VALUES in Application Development and Automation Discussions

WITHOUT INPUT VALUES

Former Member — Wed, 10 Sep 2008 10:10:22 GMT

hi to every body,

i have 2 fields city and empcode in one table,and i have one selection-option for empcode and i have on parameter for city in output.now issue is with out giving input values i want to retrive all the data,but i am validating on these fields when i retrive data from the table

select empcode

city from z_akemp into it_emp when empcode in s_empcode

city = p_city.

Re: WITHOUT INPUT VALUES

Former Member — Wed, 10 Sep 2008 10:14:49 GMT

Declare City also as select-option with NO INTERVALS option

Re: WITHOUT INPUT VALUES

Former Member — Wed, 10 Sep 2008 10:16:25 GMT

Hi,

Declare City also as select-option with NO INTERVALS and NO EXTENSION option.

Keep the Select query as it is...

Regards,

Kunjal

Re: WITHOUT INPUT VALUES

Former Member — Wed, 10 Sep 2008 10:18:14 GMT

Hello Sekhar,

With your code all the data will be fetched when the input fields are empty.

There will be no issue. But If u have any validation in selection screen U just check if the fields are initial.

But with the above syntax there will be no problem

Regards,

Subbu

Re: WITHOUT INPUT VALUES

vinod_vemuru2 — Wed, 10 Sep 2008 10:21:36 GMT

Hi,

Small correction to Kunjals reply.

Declare city also as select option with no intervals no-restriction.

But in select query where clause instead of equal to u have to use IN operator

SELECT-OPTIONS: s_city FOR kna1-city NO INTERVALS NO-RESTRICTION.

select empcode

city from z_akemp into it_emp when empcode in s_empcode

city IN s_city.

Here s_city looks like parameter but acts as select option.

thanks,

Vinod.