Fast Query Builder???

hsmhsm
edited 7:20AM in FastReport 4.0
I have bought fr4 pro (including FQB) for delphi 2009 and installed it but cannot see how to run the query designer. There is no component anywhere, the sql properties of my queries on my data page have nothing but a plain editor. There are no instructions that I can see. nothing in the program group, just a load of files placed in the C:\Program Files\FastReports\FastQueryBuilder folder.

I bought the pro because of this tool. How on earth do you get it to run?

(an old thread from member 45 in 2003 said

"assuming you have an internal db engine set of components installed, add your query component to the data page, click on the sql prop in the oi in the sql edit dialog click on the querybuilder button. "

but that does not seem to work as the sql properties do not contain a query builder button)

Howard





Comments

  • gordkgordk St.Catherines On. Canada.
    edited 7:20AM
    in the sql editor menu bar at the far left first button
  • gordkgordk St.Catherines On. Canada.
    edited 7:20AM
    you will also find more about it in the wizards section of the users manual.
  • hsmhsm
    edited 7:20AM
    gordk wrote: »
    you will also find more about it in the wizards section of the users manual.
    OK found it at last by following instructions in the wizard.

    I must say its not exactly obvious though!

    Its a handy tool but I couldn't see how it could be useful. I had a query component in my data page (delphi. not FR) to which my report was connected and was working OK. To try out FQB I added another report but although I could re connect to my database I couldn't seem to connect my report to the sql I had just designed, only to the original delphi adoquery.

    It would have been nicer if it was a stand alone tool allowing one to design and test some sql before building it into the delphi code. as it is it seems just as easy to design/test using ms access and then copy the sql over.

    unless I am missing something? I use fr to link to a delphi adoquery whose sql I insert dynamically as buttons on a form are clicked. It seems that the fqb is more for situatuions when the report source is hard coded.
    Howard

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.