Select

Former Member — Wed, 03 Feb 2010 13:50:45 GMT

Hello ,

I am developing rapport in release 6.0.

On the screen I have two parameters _par1 and _par2

I db table I have several entries with values in field1 and field2

field1 field2

1 2

3 4

5 6

If on selection screen I enter value only in _par1 and NOT in _par2 I do not get any

records in i_tab . So I enter "1 "in _par1 and nothing in _par2 and I get nothing i itab

I would expect first row from db_tab .

I tried with OR in where condition with value " 1 "in _par1 and NO values in _par2 , and than

I get ALL entries from db table in i_tab.

My question is how I can get ,for example , first row of db_table in itab

if user do not enter any value in _par2 ?

Thank you

source code .

select * from db_tab

into corresponding fields of table Itab

where field1 eq _par1 and

field2 eq _par2 .

Re: Select

Former Member — Wed, 03 Feb 2010 13:56:29 GMT

Declare the parameters as select-options and check.


select-options: s_par1 for db-par1,
                         s_par2 for db-par2.

select * from db_tab 
into corresponding fields of table Itab 
where field1 in s_par1 and 
field2 in s_par2 .

Vikranth

PS: Please use a meaningful subject line

topic Select in Application Development and Automation Discussions

Select

Re: Select