Thomas

Just being curious, when you execute this procedure in other than IBO
'enviroment' - you get the same result?
I know that IBO returns null integer as 0.

Lately, I was 'fighting' with some execute statement returning null.
I've checked all including data and the reason was missing 'SUSPEND'
When added all started to work perfectly...

My 0.02$
Marcin

W dniu 03.01.2012 13:06, Thomas Steinmaurer pisze:

> 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!
>