Subject | Re: [firebird-support] FIRST SKIP syntax |
---|---|
Author | Milan Babuskov |
Post date | 2004-07-14T17:07:29Z |
Louis Werth wrote:
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
> Don't you think by implementing your suggestion would slow down theYes.
> preparing and executing of such a qry's.
> Does anyone know if this functionality will be added in the future, orYou are asking the unnecessary. If you *really* need this, you can write
> correct me if I am asking for the unnecessary.
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