maybe

| create procedure test
| returns (TOT integer)
| as
| begin
| select count(*) from main_property
| into :tot;
suspend;
| end

----- Original Message -----
From: "Roger Pullen" <rpullen@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, March 28, 2004 11:32 AM
Subject: [IBO] Returning value from SP


| 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
|
|
|
|
|
|
___________________________________________________________________________
| IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
| without the need for BDE, ODBC or any other layer.
|
___________________________________________________________________________
| http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
| keyword-searchable FAQ, community code contributions and more !
| Yahoo! Groups Links
|
|
|
|