Your problem may be in using doble-quotes. I am d`not use quotes and all
work fine
(in IB Expert I set options "Always capitalize database object names" to
true).

You may use this:

with IB_Query1 do
begin
close; sql.clear;
sql.add('SELECT * FROM PRUEBA(?POLIZA)');
Prepare;
ParamValues['POLIZA']:=NeedPoliza;
Open;
end;

This is one of best way (tested with IBO 4.x, D5Ent anf D6Prof) - any
problems with cursors...

WBR, Dmitry Beloshistov AKA [-=BDS=-]
e-mail: torin@...

----- Original Message -----
From: "José Manuel Gómez-Ferrer y R." <sistemas@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, November 13, 2001 8:58 PM
Subject: [IBO] TIBOStoredProc as dataset?


> Hi, I'm quite new here... Using D6 & IBO4.2
>
> I can open tables and queries with no problem, but the Procedures are not
> listed in the "StoredProcName" property for the TIBOStoredProc component.
>
> If I state the procedure name manually with doble-quotes, it seem to find
it
> but I get a Create Cursor Error, this is supposed to retrieve a record
set,
> not to be executed.
>
> I changed the SQLDialect from 1 to 3 with other problems.
>
> I'm using EMS QuickDesk 2.0 Eval to edit the database properties.
>
> Procedure looks like this:
> CREATE PROCEDURE PRUEBA (
> POLIZA SMALLINT)
> RETURNS (
> ID INTEGER)
> AS
> BEGIN
> FOR SELECT PolizasD.ID
> FROM PolizasD
> WHERE PolizasD.POLIZA = :POLIZA
> INTO :ID
> DO
> SUSPEND;
> END
>
> Thanx in advance.
>
>
>
>
___________________________________________________________________________
> 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 !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>