[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