about "Access SQL Object via Code" tip

rbuser

Hi!

I have been using this tip for a long time and it works fine, but I have one
question about it...

Adding SearchCriterias to the query always adds the AND operator between
them.
If I add two "criterias" to the query using that example, it always put an
AND operator between criterias.

How can I add an OR operator, parenthesis, etc...?

Thanks!

nicocizik

Hi Santy,

You can use the TdaSQL.AddCriteria and TdaSQL.AddParentheses. The
AddCriteria takes a TdaCriteriaType parameter which can be one of the
following types...dacrField, dacrOR, dacrNOT, dacrBegin, dacrEnd.

--