>At least we all agree.

>*g*

>With regards,

>Martijn Tonies
>Upscene Productions
> <http://www.upscene.com> http://www.upscene.com

Thanks to you all, here is my solution with a statement (each ap has an
different offset and other columns)

Stored procedure.

Returns..

stmtxt = 'select lnr, lf1, lf2, lf3, lf4, lf5, lf6 from(select first '
|| (:anz_ds) || ' skip '

|| (offset + offs - anz_bef)

|| ' lnr, ' || :if1 || ' as lf1,' || :if2 || ' as lf2,' || :if3 || ' as
lf3,' || :if4

|| ' as lf4,' || :if5 || ' as lf5,' || :if6

|| ' as lf6 from t_dt order by lnr desc) order by lnr asc';

for execute statement stmtxt into :lnr, :f1, :f2, :f3, :f4, :f5, :f6 do

begin

suspend;

end





[Non-text portions of this message have been removed]