result sets from stored procs

Daniel

Delphi Developer

Tue, 30 Nov 2004 18:38:10 GMT

result sets from stored procs

Hi,
I had an app in D4 that used a stored proc to return a result set of
notifications.
It has been converted to ADO in D5 but I get the error of "CommandText does
not return a result set".
How do I fix this?

Alain Quesne

Delphi Developer

Tue, 30 Nov 2004 20:35:40 GMT

Re:result sets from stored procs

Use a TADOStoredProc and call Open instead of Exec.

Alain Quesnel
cinqsanss...@compuserve.com

Quote

"Daniel" <dan...@btsi.ws> wrote in message news:3d09c7a7_2@dnews...
> Hi,
> I had an app in D4 that used a stored proc to return a result set of
> notifications.
> It has been converted to ADO in D5 but I get the error of "CommandText
does
> not return a result set".
> How do I fix this?

uta

Delphi Developer

Fri, 03 Dec 2004 04:46:21 GMT

Re:result sets from stored procs

I have a similar problem. I've tried both TADOStoredProc and TADODataset and
get the same error message. Must be something dumb. I don't suppose anyone
has any sample code they'd like to post, that they know works, rather than
just guessing at the answer.

Quote

"Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message

news:3d09e455$1_2@dnews...

Quote

> Use a TADOStoredProc and call Open instead of Exec.

> --

> Alain Quesnel
> cinqsanss...@compuserve.com

> "Daniel" <dan...@btsi.ws> wrote in message news:3d09c7a7_2@dnews...
> > Hi,
> > I had an app in D4 that used a stored proc to return a result set of
> > notifications.
> > It has been converted to ADO in D5 but I get the error of "CommandText
> does
> > not return a result set".
> > How do I fix this?

Other Threads

1. result sets from Oracle Stored Procedures

2. D3/Oracle7.3/Stored Proc Result Sets

3. does Oracle stored proc return a result set?

4. Oracle stored procedure returning a result set

5. Oracle Stored Procedures - What no result sets????

6. result sets in Oracle stored procedures

7. getting a result set back from and Oracle Stored Procedure

8. Result sets from MS SQL 7 stored procedures

9. Stored procedure without result set

10. Stored Proc w/ no returning result set