Re: TAdoDataSet - "CommandText does not return a result set" error

Yes it returns a record set. It's the data source of a report.
I did what you suggested and used refresh and not clear. Also needed to do
"ParamByName" rather than "CreateParameter" and all is good so far.

Keith

"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
news:9fbfa1tucr6847pfgq9a7ajhqfkmh0r4dm@xxxxxxxxxx

>Everything runs fine until the last line where I get an error "dstRptTemp:
>CommandText does not return a result set."
>
>Now this does work if I set it all up manually in the properties. If I set
>up the paraemters and set Active = true I can view the report from the
>design environment. So I know my stored procedure is fine. The only
>difference I can see is that there is another parameter "@RETURN_VALUE"
that
>is automatically put in when I do it manually. I have no need for this and
>do not have one set up in the stored procedure itself.
>
>Any ideas as to what would cause this error?

Does you stored procedure return a recordset? If not you should be using
TadoCommand.
Otherwise try just
Adodataset1.Parameters.refresh;
instead of clearing and creating your parameters
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx


.

Relevant Pages

  • Re: TAdoDataSet - "CommandText does not return a result set" error
    ... >Yes it returns a record set. ... It's the data source of a report. ... >I did what you suggested and used refresh and not clear. ...
    (borland.public.delphi.database.ado)
  • Updating CR report data from vb
    ... I have a rpt with saved data that uses a stored procedure to access the ... database. ... I want to refresh the report and save the updated CR from a VB ...
    (microsoft.public.vb.crystal)
  • Re: Urgent... Crystal Report wont show data
    ... I'm just getting use to Crystal Reports. ... I notice that after I change my stored procedure you need to refresh again ... >From the Menu go to Report -> Refresh Report Data or F5, ...
    (microsoft.public.dotnet.framework.aspnet)
  • VB.NET and design-time dataset generated control
    ... One of the modules has around 7 forms and each form will print one report. ... Stored Procedure as "GetCustDetails". ... In this .xsd file, one field is manullay added called "Select" ... Now I sent the binaries to the client. ...
    (microsoft.public.vsnet.general)
  • SOLUTION: Reports in ADP based on stored procedures; child rowset error
    ... I have a report that is based on a stored ... Then I just set the report's RecordSource ... Then I had to add a second parameter to the stored procedure. ... RecordSource property from my ADP report into the immediate window, copy it, ...
    (microsoft.public.access.reports)