Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Refreshing data from database

edited February 2005 in End User
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

Comments

  • edited February 2005

    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
  • edited February 2005
    > 1. Make sure that your event-handler code is being called

    It is.


    How can I do that in RAP, inside the event ?

    Thanks again,

    Mauro Assis


    the
    changes,
  • edited February 2005

    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
This discussion has been closed.