ADOCommand or ADODataset and Postgres

From: Alexander Hachmann (alexander_at_hachmann-online.de)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 18:45:01 +0200

Hello,
I am writing a small application for organising Articles and Products.
I use PostgresSQL 7.4 and Delphi 7.0

What I need to do is simply recieving Datasets from a Stored Procedure. As I
read in Andreas Koschs book "Ado and Delphi" this should be very simple.
But the example did not work with Postgres. (The books examples are done
with MS SQL-Server)

I use the ADODataSet from the dbGo-Family, set commandtype to
cmdStoredprocedure and the commandtext to the Procedures name.
I set the parameters as well.
When the procedure simply returnes an integer value and no sets, it works
fine like this. But, when I need to recieve a set of Records, it does not
work.

"ERROR : set-valued function called in context that cannot accept a set" is
the Message that the EDatabase-Exception sais.

What do I have to care of, that I could have missed. The Procedure works
fine in pgAdminIII and the ADODataset works fine with procedures
that return simple values.
I would be very pleased if anyone could help me.
Thx,
     Alexander

Quantcast