topic Re: data retrival in Application Development and Automation Discussions

data retrival

Former Member — Wed, 29 Nov 2006 06:11:57 GMT

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.

Re: data retrival

jayanthi_jayaraman — Wed, 29 Nov 2006 06:14:05 GMT

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.

Re: data retrival

anversha_s — Wed, 29 Nov 2006 06:14:32 GMT

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

case select option.

select * from ......where field IN s_sel

hope u understud

anver

Re: data retrival

Former Member — Wed, 29 Nov 2006 06:16:02 GMT

Hi,

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

hope you understood.

Rgds,

Ajith

Re: data retrival

Former Member — Wed, 29 Nov 2006 06:16:16 GMT

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