Open / Close Query on a Band Event ?

DevNico

Hy,

I want to know, if it possible on a band event (Before Print) to :
Close an Internal Query
Modify a Parameter
Open the Query

thank.

DevNico

NoBoby ?

gordk

yes but not the query of the current dataset.

DevNico

Ok thank for your response.
Anyone has an exemple of this ode, i didn't find it on my help file .
thank

gordk

queryname.close;
sample query
select * from customer
where custno = :p1
in the params editor set the params datatype and point its value to a variable.
in code
close query
set the variables value
open query.
see sample report in main demo under internal datasets it points the param to the editbox.

What are you trying to acheive?

DevNico

thank for your response [img]style_emoticons/<#EMO_DIR#>/biggrin.gif" style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif" /> I want to Use These for trying to resolve my problem of refresh of my query that execute the subreport in this thread :[/img] http://www.fast-report.com/en/forum/?p=/discussion/7046