general selection screen doubt

[Former Member]

Hi

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 .

[Former Member]

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

[Former Member]

Hi,

Both are same eventhough declarations are different.

Sreedhar

[Former Member]

Hi,

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

so, both are same.

regards,

keerthi

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

ur right....

pl. award points and close the thread.

[Former Member]

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