[Lazarus] Reading result of a Firebird stored-procedure

Koenraad Lelong lazarus1 at de-brouwerij.be
Mon Mar 7 17:24:13 CET 2011


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 ?
I made a query with sqldb :
execute procedure GEN_STA_NR returning_values :STA_NR
Then I executed that, but that gave an error. After googleing, I
modified the query to :
execute procedure GEN_STA_NR returning_values (:STA_NR)
Still gave an error when executing the query.
More googleing found a thread (26-3-2009) where someone said to make the
stored procedure selectable. How could I make my stored-procedure
selectable ?

Thanks for any pointers,

Koenraad Lelong.




More information about the Lazarus mailing list