Home DADE

Query Wizard - only tables? Not Views?

edited February 2010 in DADE
hello.
I'm using Rbuilder Pro 10 with D7.
I want to be able to use DADE Query Wizard to make my reports, but in the
wizard are only listed the tables. I have some views I would like to use.
Can this be done?
I want to use the AutoSearchCriteria in the views and if I enter the SQL
manually I can't do this.
Any tips?
Thanks in advance

Best Regards

Goncalo Martins

Comments

  • edited February 2010
    Hi Gonçalo,

    The items displayed for the available tables in the query wizard is
    controlled by the DADE plugin that connects to the database. The
    TdaSession.GetTableNames routine performs this task.

    For instance the TdaADO plugin returns all tables and views in this routine.
    Depending on which database and connectivity you are using, you should be
    able to update the plugin to support views. See the daADO.pas file for
    reference.

    --
    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.