On Mon, 7 Mar 2011, Jesus Reyes wrote:
--- El lun 7-mar-11, Koenraad Lelong <[email protected]> escribió:
De: Koenraad Lelong <[email protected]>
Asunto: [Lazarus] Reading result of a Firebird stored-procedure
A: "Lazarus mailing list" <[email protected]>
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.
Only if you want to return multiple records. For 1 record, the exit puts the
data on the return data stream.
Michael.
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
