Subject Returning value from SP
Author Roger Pullen
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