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

How to override TdaADOSession.GetTableNames ?

edited September 2005 in End User
Hi gurus,

I need to control what table/view names are displayed to user in query
designer/wizard. What the best way and place to accomplish this ?

Thanks in advance,
Dmitry

Comments

  • edited September 2005

    1.Use the TppDataDictionary to define what table and fields the end-user can
    accessa and to define user friendly table and field aliases. You can
    optionally pre-define join conditions as well. See the tutorials in the
    Developers Guide and the RBuilder\Demos\EndUser\AutoJoin example.

    2. If you need to include views in the list of tables and they are not
    showing up, then you will need tomodify the TdaADOSession.GetTableNames
    method to include the views.


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


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited September 2005
    Thanks a lot Nard.

    View names are displaying for ADO session by default, you don't need to
    modify anything. I remember it was not a case for IB/Firebird though.
    And yes, I will use TppDataDictionary.

    Cheers,
    Dmitry

This discussion has been closed.