topic Re: general selection screen doubt in Application Development and Automation Discussions

general selection screen doubt

Former Member — Tue, 21 Nov 2006 14:50:18 GMT

what is the difference between the following two

selection screen

select-options:sid FOR Zxxx-ID NO-EXTENSION NO INTERVALS.

parameters : sid like zxxx-id.

I KNOW I HAVE TO USE IN FOR FIRST AND = FOR SECOND IN SELECT QUERIES.

Apart from that is there any difference that has to be taken care in the program

Thanks .

Re: general selection screen doubt

Former Member — Tue, 21 Nov 2006 14:52:37 GMT

... NO-EXTENSION

Effect

The user can only make an entry on one line. Calling the additional "Multiple Selection" screen is not supported and no pushbutton for this appears on the selection screen.

Addition 12

... NO INTERVALS

Effect

The selection option is displayed on the selection screen without a 'to' field. The pushbutton for calling the "Multiple Selection" screen appears immediately after the 'from' field.

This addition thus allows you to generate a simplified display on the selection screen. This is particularly useful if you are not making any range selections for this selection option.

<b>with this ranges can be included where as with parameters they cannot be included</b> ..

Regards,

Santosh

Re: general selection screen doubt

Former Member — Tue, 21 Nov 2006 14:52:52 GMT

Hi,

Both are same eventhough declarations are different.

Sreedhar

Re: general selection screen doubt

Former Member — Tue, 21 Nov 2006 14:57:46 GMT

Hi,

select options with no intervals and no extension works like parameter.

so, both are same.

regards,

keerthi

Re: general selection screen doubt

Former Member — Tue, 21 Nov 2006 14:58:02 GMT

with the first statement ,

if u doesnt give any input value for the select-option , it will fetch all the values when used in select query

but with the second statement , if the parameter value is empty it will not fetch any record when used in select statement

Re: general selection screen doubt

Former Member — Tue, 21 Nov 2006 14:59:18 GMT

both are same when u enter values and execute ur program...but when u leave blank in select statement for select-option it fetches all records where as for parameter it will fetch only that record which is equal to space.

Re: general selection screen doubt

Former Member — Tue, 21 Nov 2006 15:22:20 GMT

Hi,

so its advisible to use

select-options:sid FOR Zxxx-ID NO-EXTENSION NO INTERVALS.

whenever you have chice of multiple entries in selection thatmeans if you other fields in selection scrren and you can leave the field blank.

where as if you parameters you cannot leave this field blank right.

LET ME KNOW IF IAM RIGHT.

Thank you all

Re: general selection screen doubt

Former Member — Tue, 21 Nov 2006 15:26:02 GMT

ur right....

pl. award points and close the thread.

Re: general selection screen doubt

Former Member — Tue, 21 Nov 2006 15:34:22 GMT

Hi Maya,

The only difference is the behaviour of this variables in the select statement.

If nothing is passed to s_sid then the select statement is sccessful. but if noting is passed to p_sid(parameter) and you are equating this in the select statement then the select statement will fails.

Regards,

Satya