|Subject||AW: [firebird-support] select first and skip|
>At least we all agree.Thanks to you all, here is my solution with a statement (each ap has an
> <http://www.upscene.com> http://www.upscene.com
different offset and other columns)
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
[Non-text portions of this message have been removed]