Refreshing data from database

rbuser

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

nardmoseley

You might try calling Report.Reset and Close the stored proc, set the
params, and re-open it.

--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com

rbuser

Close the stored proc ? I run the stored proc, it doesn't returns any result
set. It fill a table in db matching the parameters the user set.