topic Re: Record selection in Application Development and Automation Discussions

Record selection

sanju_joseph — Fri, 17 Oct 2008 08:38:02 GMT

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

Re: Record selection

MarcinPciak — Fri, 17 Oct 2008 08:42:22 GMT

Use:

SELECT...UP TO 800 ROWS.

It will result in max 800 hits.

Re: Record selection

Former Member — Fri, 17 Oct 2008 08:42:54 GMT

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.

Re: Record selection

former_member203501 — Fri, 17 Oct 2008 08:43:14 GMT

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

regards,

venkat

Re: Record selection

sanju_joseph — Fri, 17 Oct 2008 08:44:45 GMT

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

Re: Record selection

Mohamed_Mukhtar — Fri, 17 Oct 2008 08:49:25 GMT

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

Re: Record selection

Former Member — Fri, 17 Oct 2008 08:52:08 GMT

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

Re: Record selection

sanju_joseph — Fri, 17 Oct 2008 08:56:35 GMT

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