SQL 2000 and stored procedures
I've noticed from earlier posts in the RB NG's that using stored procedures
as report sources is a real PIA. But those are fairly old posts. I've just
recently downloaded the trial version 9. I am finding it quite impossible
to use a stored procedure although I can't really say I know what I'm doing
just yet.
I have a TAdoDataSet whose command text is a stored procedure from my SQL
backend (I can access the fields from other controls such as grids, so I
know it's working just fine). Then I have a TDataSource whose DataSet
property is set to my TAdoDataSet. Then I tried setting the DataSource
property of my TppDBPipeline to the TDataSource and the DataPipeline
property of my TppReport is set to my TppDBPipeline. Of cousre when I try to
set up a data whatever (not sure of your lingo) in the data tab of the
designer, all I can see are my tables and views from my backend. It's like
it doesn't even have a clue that I've got my TAdoDataSet already connected
to the stored procedure.
I use stored procedures for reports all the time. I need to know not only if
this is possible with RB but how to do it so I can properly evaluate the
tool.
Can anyone provide me with some really detailed information on how to do
this? I'm not finding it intuitive at all.
Would really appreciate some info here.
Thanks,
Keith
as report sources is a real PIA. But those are fairly old posts. I've just
recently downloaded the trial version 9. I am finding it quite impossible
to use a stored procedure although I can't really say I know what I'm doing
just yet.
I have a TAdoDataSet whose command text is a stored procedure from my SQL
backend (I can access the fields from other controls such as grids, so I
know it's working just fine). Then I have a TDataSource whose DataSet
property is set to my TAdoDataSet. Then I tried setting the DataSource
property of my TppDBPipeline to the TDataSource and the DataPipeline
property of my TppReport is set to my TppDBPipeline. Of cousre when I try to
set up a data whatever (not sure of your lingo) in the data tab of the
designer, all I can see are my tables and views from my backend. It's like
it doesn't even have a clue that I've got my TAdoDataSet already connected
to the stored procedure.
I use stored procedures for reports all the time. I need to know not only if
this is possible with RB but how to do it so I can properly evaluate the
tool.
Can anyone provide me with some really detailed information on how to do
this? I'm not finding it intuitive at all.
Would really appreciate some info here.
Thanks,
Keith
This discussion has been closed.
Comments
When using the Data Workspace (data tab), there is no need to create the
TDataSet - TDataSource - TppDatapipeline components on your form.
ReportBuilder handles all of this internally. However currently there is no
support built-in to the Query tools for supporting
views or stored procs.
Internally the DADE Plug-ins (i.e. daADO.pas) create a QueryDataView
descendant class. See the DADE thread of Tech Tips newsgroups for an
overview of the architecture. A QueryDataView can work with the
QueryDesigner and QueryWizard tools. Internally the QueryDataView creates a
DataSet, DataSource, and DataPipeline. For example, ADOQueryDataView creates
an ADOQuery, TDataSource, and DBPipeline.
To support StoredProcs you can create custom dataview - see
RBuilder\Demos\EndUser\Custom DataViews for examples.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com