Refreshing data from database
I posted the following message at this news groups in 02/17, but it doesn't
appears, so ...
Hi,
I'm using RB 6.02, Delphi 5.0
I've created a customized RAP function the runs a StoredProcedure in the
database. So, I call this function in OnAutoSearchDialogClose, passing the
user parameters' set. The report is a crosstab report.
The first time I open the report, it works fine. However, if the user
changes the values of the parameters and runs the report again, the changes
doesn't appears at the report, despite the table in the database changes,
that is, the procedure run fine with the new values.
How can I make a refresh of the data in this case ?
Thanks in advance,
Mauro Assis
Athena
appears, so ...
Hi,
I'm using RB 6.02, Delphi 5.0
I've created a customized RAP function the runs a StoredProcedure in the
database. So, I call this function in OnAutoSearchDialogClose, passing the
user parameters' set. The report is a crosstab report.
The first time I open the report, it works fine. However, if the user
changes the values of the parameters and runs the report again, the changes
doesn't appears at the report, despite the table in the database changes,
that is, the procedure run fine with the new values.
How can I make a refresh of the data in this case ?
Thanks in advance,
Mauro Assis
Athena
This discussion has been closed.
Comments
1. Make sure that your event-handler code is being called
2. Make sure that you close the Dataset and re-open it.
--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
It is.
How can I do that in RAP, inside the event ?
Thanks again,
Mauro Assis
the
changes,
Try calling DataPipeline.Close for the datapipeline to which the dataset is
connected.
If you find that you need to call methods that RAP does not know about, then
you can easily extend RAP. See the following article.
--------------------------------------------------
Article: Extending RAP
---------------------------------------------------
There are two very simple and powerful techniques to extend the capabilities
of RAP infinitely. These are summarized below and covered in more detail in
the RAP.hlp online help. Demos and tutorials are installed to
RBuilder\Demos\RAP. The tutorial text is located in RAP.hlp.
1. RAP Pass-Through Functions
These are functions that appear in the Language tab of RAP's Code Toolbox.
These functions are written in Delphi and can be called from RAP. RAP's
pass-through function architecture enable's developers to add new built-in
functions to RAP's code toolbox.
2. Extend RAP's RTTI
RAP's Run-time Type information defines what classes and properties can be
accessed via RAP. By default the published properties of any class that is
registered with Delphi's RegisterClass procedure is recognized by RAP. In
addition many of the public properties and methods of ReportBuilder classes
are exposed.
--
Tech Support mailto:support@digital-metaphors.com
Digital Metaphors http://www.digital-metaphors.com
--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com