Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

SQLBuilder termporary changes

edited June 2006 in General
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.

Comments

  • edited June 2006
    Hi Rick,

    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.