SQLBuilder termporary changes
In D6 RB9.02 I want to add some additional search criteria based on my
business logic, potentially (but not always) to every pipeline
I have implemented the OnInitializeParameters event and using
TdaSQLBuilder I am able to very nicely optionally add a restriction.
However, the restrictions change and are not to be shown in the query
designer to the user.
Ideally I would like to apply them, execute the queries, then restore
the original TdaSQL - or safely remove the added criteria.
Is there a clean way for me to do this? If not, can you suggest where
I should start?
Many thanks.
Rick Matthews
FDM Software Ltd.
business logic, potentially (but not always) to every pipeline
I have implemented the OnInitializeParameters event and using
TdaSQLBuilder I am able to very nicely optionally add a restriction.
However, the restrictions change and are not to be shown in the query
designer to the user.
Ideally I would like to apply them, execute the queries, then restore
the original TdaSQL - or safely remove the added criteria.
Is there a clean way for me to do this? If not, can you suggest where
I should start?
Many thanks.
Rick Matthews
FDM Software Ltd.
This discussion has been closed.
Comments
You can safely remove any criteria you create using the
TdaSQLBuilder.SearchCriteria.Remove routine. This would essentially restore
the original TdaSQL object for you. Take a look a the TdaSQLCriteriaList
topic in the RBuilder help file for information on how to alter the search
critera to your needs.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com