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