refresh DBpipeline

rbuser

Hi,

If I change a dataset I want to refresh the DBpipeline designtime. But that
seems to be very difficult. Most of the time I add a new field, get an
access violationerror, restart delphi and then the DBpipeline refreshes.

I think there must be a better way to do this. I use D5 and RB7.x ( the
latest version)

Leon Bemmelmans

nicocizik

Hi Leon,

I am unclear about what you are ultimately trying to accomplish.
ReportBuilder was designed to handle pre-processed data from a dataset whose
query has already been executed. I do not think it would be possible to
actually change the values in the database while the report is running. As
a workaround, you might consider using an in-memory dataset and instead of
changing the values in the database, change the values in that, which can
then later be writen to the database.

--

rbuser

Nico,

My problem is that when I add fields to the database (new fields to a table)
that need to be printed those fields are not present in my pipeline. I would
like reportbuilder to add those fields to the pipeline in designtime (while
designing my application an reports).
In the fieldseditor of reportbuilder I can press the button "fill from
dataset" (or something like that) but that results most of the time in an
access violation. I then have to shut down Delphi and load Delphi again in
order to let reportbuilder refresh the pipeline.

Leon

nicocizik

Leon,

I am a bit unclear about when this AV is occuring. Are you taking about the
Fields Editor that can be accessed from the DBPipeline object from the form
at design time, or the DADE Fields Editor at design time? (meaning no
application is running). I am unaware of the "Fill from dataset" button in
the fields editor. If at designtime you change the dataset, you will need
to set your table or query component's Active property to false and perhaps
clear out the fields of the DBPipeline befor updating the database. If this
does not help, simply delete and re-add the DBPipeline object and reconnect
it to the datasource.

--