Subject | 4.9.14b32 - Problem with executable SP and output parameters |
---|---|
Author | Thomas Steinmaurer |
Post date | 2012-01-03T12:06:57Z |
Hello Jason,
migrating a legacy app from D2006 to D2010 for Unicode support.
Currently I'm using 4.9.14b32.
I have an executable SP (no SUSPEND in the SP) with a few input
parameters and one output parameter:
SET TERM ^^ ;
CREATE PROCEDURE P_1 (
...
)
returns (
VAR_ID Numeric(18,0))
AS
BEGIN
VAR_ID = GEN_ID(MYGEN, 1);
...
END ^^
SET TERM ; ^^
In the application I'm using a TIB_StoredProc and:
...
myProc.ExecProc;
...
myVar := FieldByName('VAR_ID').AsInt64;
While this has worked in previous IBO versions, even in earlier 4.9.14
versions, with b32, myVar is always 0.
Any ideas?
Thanks!
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist
http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/
migrating a legacy app from D2006 to D2010 for Unicode support.
Currently I'm using 4.9.14b32.
I have an executable SP (no SUSPEND in the SP) with a few input
parameters and one output parameter:
SET TERM ^^ ;
CREATE PROCEDURE P_1 (
...
)
returns (
VAR_ID Numeric(18,0))
AS
BEGIN
VAR_ID = GEN_ID(MYGEN, 1);
...
END ^^
SET TERM ; ^^
In the application I'm using a TIB_StoredProc and:
...
myProc.ExecProc;
...
myVar := FieldByName('VAR_ID').AsInt64;
While this has worked in previous IBO versions, even in earlier 4.9.14
versions, with b32, myVar is always 0.
Any ideas?
Thanks!
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist
http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/