9.02 and TdaSQLBuilder

rbuser

I need to add a criteria to every dataview. This criteria will change
based on who is running the report so I don't want it saved with the
report.

I am using the Report Explorer with end user reporting , so what event
should I be implementing so that I can do this (not from RAP since
this is not under the users control)? If in the designer how do I
stop the changed dataview from being persisted?

Would you have a close example project?

Many thanks.
Rick Matthews
FDM Software Ltd.

nardmoseley

Modify the DADE plug-in and place the code in the QueryDataView.SQLChanged
method. This is the method that assigns the SQL text generated by the TdaSQL
object to the DataSet.

For example, open daADO.pas and check out TdaADOQueryView.SQLChanged.

This approach will keep the security code separate from the TdaSQL.



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

rbuser

Thanks very much - isolated is what I was looking for.

Cheers,