Open / Close Query on a Band Event ?

edited July 2010 in FastReport 4.0
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.

Comments

  • edited 2:04AM
    NoBoby ?
  • gordkgordk St.Catherines On. Canada.
    edited 2:04AM
    yes but not the query of the current dataset.
  • edited 2:04AM
    Ok thank for your response.
    Anyone has an exemple of this ode, i didn't find it on my help file .
    thank
  • gordkgordk St.Catherines On. Canada.
    edited 2:04AM
    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?
  • edited July 2010
    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

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.