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

Query builders

edited September 2006 in General
Is it possible to register new items for the Query builder (On the data
tab) based on the existing ones?

Regards
Charles

--- posted by geoForum on http://delphi.newswhat.com

Comments

  • edited September 2006
    Hi Charles,

    Are you trying to add to the query designer toolbar? This is not something
    that is natively built-in to ReportBuilder. What exactly are you trying to
    accomplish?

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited September 2006
    Hi Nico,

    Within the designer you have the Data tab, you then create a new query. At
    this point a small window with 2 options appears, Query wizard, and Query
    Designer. I was wondering if it is possible to create a new type based on
    one of the existing ones?

    We have a customised version of RB6 and are looking at upgrading. Some of
    the things we have added to the query builder, is our own date
    funtionality, and depending on the field type, a button appears which
    enables some other custom code.

    One of our goals is to make sure we allow easy upgrade by using
    inheritence instead of changing the standard code base. Hence the question.

    Regards
    Charles

    --- posted by geoForum on http://delphi.newswhat.com
  • edited September 2006
    Hi Charles,

    Thanks for the clairification. Yes this is definitely possible. You will
    need to have your custom query designer descend from the TdaCustomDataWizard
    class. Take a look at the following example of how this can be done. You
    will notice that in the TmyQueryDesigner, three class functions are
    overriden which define the bitmap to be used in the "new" dialog, the
    description, and the dataview class to be used as well (if you created a
    custom one).

    class function ClassBitmap: THandle; override;
    class function ClassDescription: String; override;
    class function DataViewClass: TdaDataViewClass; override;

    Finally in the initialization section you can see that the original
    QueryDesigner is unregistered and the new one is registered with DADE. If
    you would like to leave the original, you would simply need to register your
    new one.

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

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.