Access SQL for ppViewer

rbuser

We have constructed a report viewer form using the ppViewer. During
runtime, we want to give the user the ability to access the underlying SQL
(created in the Report Designer) so that they can modify the SQL to change
the content of the report in the Viewer.

Is there a source code example of how to do this?

Thanks, Patrick

nicocizik

Hi Patrick,

There are many ways of accessing the SQL object, the easiest being through
the TdaSQLBuilder class. TdaSQLBuilder gives you an easy-to-use wrapper
around the SQL object which is very complex and difficult to use in most
cases. See the articles below and take a look at the TdaSQLBuilder topic in
the RB Help.

http://www.digital-metaphors.com/rbWiki/DADE/SQLBuilder

--
Regards,

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