legrand_legrand_63 wrote:

> Alexandre,
> I apologize, you are perfectly right
> ROWNUM is an Oracle (and Fyracle) pseudo columns.
> But Firebird implements ROW_COUNT (in PSQL only)
> try this:
>
>

...snip...

> that would have been great to have it directly in SQL ;o)
>
> Regards
> PAscal
>
>
>

In FB 2.0 you coud use the new EXECUTE BLOCK construct.

try this:

EXECUTE BLOCK RETURNS (
NUM INTEGER,
NAME CHAR(31))
AS
begin
For
select
row_count,
rdb$relation_name from rdb$relations
into :num, :name
do
begin
suspend;
end
end;

;-)

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br