[Lazarus] Reading result of a Firebird stored-procedure

[Jesus Reyes]

--- El lun 7-mar-11, Koenraad Lelong <lazarus1 at de-brouwerij.be> escribió:

> De: Koenraad Lelong <lazarus1 at de-brouwerij.be>
> Asunto: [Lazarus] Reading result of a Firebird stored-procedure
> A: "Lazarus mailing list" <lazarus at lists.lazarus.freepascal.org>
> Fecha: lunes, 7 de marzo de 2011, 10:24
> Hi,
> 
> I have a stored-procedure in Firebird, to generate a
> primary key :
> CREATE PROCEDURE GEN_STA_NR
> RETURNS (
>     STA_NR Integer )
> AS
> begin
>  STA_NR=gen_id(StaffelNr_GEN, 1);
> end^
> 
> How do I get the result ?

beside to the answers you already obtained, it seems in order a stored procedure return something you must call SUSPEND for each record.

Jesus Reyes A.