Record selection

[sanju_joseph]

Hello Experts,

there is any way by which we can restrict the record of database to be selected , for example if my table have 1000 record and

i am interested in picking record from row 500 to 800 .

Regards,

Sanju

[MarcinPciak]

Use:

SELECT...UP TO 800 ROWS.

It will result in max 800 hits.

[Former Member]

Hello,

I am not sure you can choose rows 500-800 but you could use the UP TO X ROWS clause in the select statement (set X to 800) to retrieve the first 800 rows and then discard the first 499.

Regards,

Steve.

[sanju_joseph]

thanks for the reply,but i am interested at time of selection , and don';t want to do any calcualtion after that

[Mohamed_Mukhtar]

Hi Joseph,

Set default values to your select-option

Example

Initialization .
S_option-low = 500.
S_option-high = 800.
S_option-sign = 'I'.
S_option-option = 'BT'..

append S_option.

Thanks

Edited by: Always Learner on Oct 17, 2008 10:49 AM

[former_member203501]

hi i think this will happend with setting a flag(a new field) in database table and populate it with X .

regards,

venkat

[Former Member]

you can initialise in select-options,

or while writing it you use

loop at itab from 500 to 800.

write:/

endloop.

Edited by: janagar sundaramoorthy on Oct 17, 2008 10:53 AM

[sanju_joseph]

flag option specified by venkat looks good , but the real question is if some new records are inserted in table then flag should

hold the value of the row it is pointing to , don;t know how that

can be done automatically