Generated SQL

rbuser

Hi there,

Im using RB7 with D6 and SQL Server using DADE


When executing a report template ( preview or print - not from inside the
designer) where is the nest place for me to examine the exact sql statements
that are sent to the sql server? I presume it will be somewhere close to
where the dataviews are actually opened?

Any pointers would be welcome.

Cheers,
Ben

digitalmetaphors

You can extract the TdaSQL object when the report is loaded
Report.Template.OnLoadEnd event. In this event, hook up a communication with
this object (call AddEventNotify) with a TppCommunicator you create. In your
communicator, listen for the ciAfterGenerateSQL eventID. This will tell you
that you can check the SQL that was just created which will be sent to the
server in a query. I don't have an example, but an example of using a
communicator in your form can be found in this example:

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

Here is an example of extracting the TdaSQL object. There is one SQL object
in every dataview in the TdaDatamodule of a report.

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

Cheers,

Jim Bennett
Digital Metaphors