data retrival

[Former Member]

hi experts,

we have parameter and select-options in selection screen.if we can't provide any values in options what will be the output. and if we can't provide any values in parameters what will be the output.

thanks in advance.

[jayanthi_jayaraman]

Hi,

Parameters : If no value is given,nothing will be displayed.

select-options:If no value given,everything will be displayed.

KIndly close the thread by pressing the star on the left of reply,if your query is solved.

[anversha_s]

hi,

if we are giving no parameters, no value will take.

in select - optuons it will fetch qll the values from DB.

case parameter.

select * from ......where field<b> =</b> p_para.

case select option.

select * from ......where field <b>IN</b> s_sel

hope u understud

anver

[Former Member]

Hi,

<b>

I no values in select options and in select statement you use IN ,then all the values from the table will be retrieved.

if you use parameter and give ' =' p_value' in select statement ,and if u dont give any value in the parameter then no value will be fetched...</b>

hope you understood.

Rgds,

Ajith

[Former Member]

hi

in Select-options the select statement select all the data from the table.

in Parameters the select statement is not select the data from the table.

Regards

Usman