Subject | Returning value from SP |
---|---|
Author | Roger Pullen |
Post date | 2004-03-28T18:32:01Z |
Hi - am going nuts here on what should
be a simple task....
Firebird 1.0
Consider this SP - all it does is return
the total count of a table
create procedure test
returns (TOT integer)
as
begin
select count(*) from main_property
into :tot;
end
In IB Expert it returns a value as expected
using "execute procedure test"
However, in IBO (4.x) it returns NULL
as do other procedures
Does IBO do things differently. Marathon, written
with IBO seems to behave the same
Regards
Roger Pullen
be a simple task....
Firebird 1.0
Consider this SP - all it does is return
the total count of a table
create procedure test
returns (TOT integer)
as
begin
select count(*) from main_property
into :tot;
end
In IB Expert it returns a value as expected
using "execute procedure test"
However, in IBO (4.x) it returns NULL
as do other procedures
Does IBO do things differently. Marathon, written
with IBO seems to behave the same
Regards
Roger Pullen