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

Query Designer Usage

edited November 2003 in DADE
I have successfully implemented RB 7.03 into my applications. In designing
the reports, I became quite comfortable with the Query Designer as a quick
query building tool. I am confident my customers will do the same.

I am would like to use the Query Designer in other non-reporting areas of my
application where users can build a quick query. Is this possible and can
you provide me with information on how to do so?

Thanks,
Bob Tucker
www.ExpressTechnology.com

Comments

  • edited November 2003

    This can be achieved, though it was not designed with that purpose in mind.
    :)

    Here is an example:

    http://www.digital-metaphors.com/tips/QueryDesignerViaCode.zip


    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited November 2003
    Thanks.
    Bob Tucker

  • edited January 2009
    Nard:

    I tested the below example and works excellent, but if I load a query saved
    to a database with the:

    FMemoryStream.Size > 0 then LoadSQLFromStream(FSQL, FMemoryStream); command
    the query designer doesn't autojoin my tables why?

    the first time I run your querydesignerviacode demo it allow autojoins
    feature but not if I load a previous saved query to a database.


    Regards


    "Bob Tucker" escribi? en el mensaje
This discussion has been closed.