CODEWITHSUNDEEP
delphistored-proceduresfirebirddelphi-xefirebird2.5
Antonio
Antonio

Reputation: 1

Cursor not returned from Query

I'm using Delphi XE and FireBird 2.5.

Try use a TSQLStoredProc and give me the error "Cursor not returned from Query" when I put the Active property to TRUE.

An dummy example of storedproc

CREATE PROCEDURE NEW_PROCEDURE
RETURNS(
  RDO SMALLINT)
AS
BEGIN
  Rdo = 5; 
  /* Procedure body */
  SUSPEND;
END;

Upvotes: 0

Views: 2232

Answers (2)

Ondrej Kelle
Ondrej Kelle

Reputation: 37221

As a workaround, a query like SELECT * FROM NEW_PROCEDURE should work (using TSQLQuery).

Upvotes: 3

Stefaan
Stefaan

Reputation: 502

I think you are supposed to use the ExecProc method instead of Open / Active. Setting Active to true should only be used if your SQL Statement returns a ResultSet (a set of records), which yours doesn't.

Regards,

Stefaan

Upvotes: 2

Related Questions