topic Re: Parameters in Open SQL in Application Development and Automation Discussions

Parameters in Open SQL

Former Member — Tue, 22 May 2007 16:27:56 GMT

Hi,

I have defined a parameter:

PARAMETERS: p_param1 LIKE table-cod_param1

I need to use this parameter in a SQL Sentence and this parameter isn´t obligatory.

How I can build de sentence ?? I don´t have problems if the parameter is defined as select-options.

(this is an example, my sql sentence has many parameters)

Select * into it_table

from table

where cod_param1 = p_param1

Thanks

Re: Parameters in Open SQL

Former Member — Tue, 22 May 2007 16:30:55 GMT

Hello,



PARAMETERS: p_param1 LIKE table-cod_param1

if p_param1 is initial.
Select * into it_table
from table .  " No where condition
else.
Select * into it_table
from table
where cod_param1 = p_param1
endif.

Regards,

Deepu.K

Re: Parameters in Open SQL

Former Member — Tue, 22 May 2007 16:35:32 GMT

Since this parameter is not an obligatory field it is always better to declare this as select options

SELECT-OPTIONS: p_param1 for table-cod_param1

if not p_param1[] is initial.

Select * into it_table

from table

where cod_param1 in p_param1.

endif.

If it is declared as parameter, when you don't enter a value it will take space as default value and fetch the wrong data.

where as in select options, even if you don't enter any value it will take all values and fetches the correct values.

Reward points if useful

Regards

Anji