DB Views Support update

rbuser

Hello,

In 2003, ReportBuilder did not support Table Views.

"Table Views are not supported in the currently release. However, we
have had a few customers modified the DADE plug-ins for various
database, to add support for view. The TdaSession.GetTableNames method
is the responsible for returning the list of available tables." ~ Nico

Is this still the case?

I see that one could write custom code to implement this, but I am
reluctant to do.

Thanks,

Phil Horst

nicocizik

Hi Phil,

We have updated some of the DADE plugins to support views such as the ADO
plugin however it may be necessary to update the plugin you are using to
support views in your application. One of the main reasons we implemented
the plugin architecture for DADE was so that you the developer can tailor it
to meet your needs.

The items displayed for the available tables in the query wizard is
controlled by the TdaSession.GetTableNames routine in the DADE plugin.

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

rbuser

Thanks for the tip. This turns out to be easy - with your architecture.

Best,
Phil