Adding OR clause to search criteria at run-time

rbuser

Hi there - I'm using RB7 with D5 Ent,

I would like to be able to set up an OR clause for one particular field on a
report by creating some search criteria at run-time. I know that there is
a criteria type for OR clauses (dacrOR), but I can't get this to work.

Any examples would be much appreciated.

Thanks in advance,

Ray Allen.

digitalmetaphors

You can extract the TdaSQL object an dthen insert a criteria object. Here
is ane example which takes a dataviwe which has one criteria, adds an Or,
adds a new criterita and then modifies the new criteria after it was added.

http://www.digital-metaphors.com/tips/AddSearchCriteria.zip

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Jim,

Thanks for the reply, I was able to add the OR clause using the method you
suggested.

Ray Allen