Subject Re: [firebird-support] FIRST SKIP syntax
Author Milan Babuskov
Louis Werth wrote:
> Don't you think by implementing your suggestion would slow down the
> preparing and executing of such a qry's.

Yes.

> Does anyone know if this functionality will be added in the future, or
> correct me if I am asking for the unnecessary.

You are asking the unnecessary. If you *really* need this, you can write
a simple stored procedure to do it for you. (Although I don't see why
you can't simply issue two queries). Example:

create procedure WHATEVER
returning (
column1 integer,
column2 char(10),
rowcount integer)
as
begin
select count(*) from table into :rowcount;
for
select column1, column2
from table
into :column1, :column2
do
suspend;
end


To use it, just do a:

select * from WHATEVER;

HTH

--
Milan Babuskov
http://fbexport.sourceforge.net