Subject | TIBOStoredProc as dataset? |
---|---|
Author | José Manuel Gómez-Ferrer y R. |
Post date | 2001-11-13T18:58:02Z |
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.
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.