Trying to filter a template query. Is it possible?

rbuser

Hi!

I have used the SetSQLObject(aReport: TppReport) and GetSQLObject(aReport:
TppReport) functions you gave me for getting or changing the SQL database of
a saved rtm template.

Now I'm investigating if is it possible to add a filter to de sql query
result of that template.
With the following line, I can see the "sql query text":

[...]
TdaQueryDataView(lDataView).SQL.SQLText.Text
[...]

and it shows successfully, but...
Is it possible to apply a filter to this query?

For example:
If the "sql query text" contains the "Sale_Date" field, I would like to
filter the result.
Something like this:

if pos('Sale_Date',TdaQueryDataView(lDataView).SQL.SQLText.Text) <> 0 then
TdaQueryDataView(lDataView).SQL.Filter := "Sale_Date =
.................'

Is it possible?
Thanks!

rbuser

This is a question, being discussed in various threads already.

e.g.
instead

HTH
Bernd

nardmoseley

DADE is designed to support autosearch criteria, which are used to
dynamically generate the SQL Where clause. There is no built-in support for
filtering a dataset.

Top pursue this you would need to create your own custom dataview classes.
See daADO.pas and the DADE thread of the Tech Tips newsgroup for more
informatino. There are also classes in RBuilder\Demos\EndUser\Custom
DataViews.


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