How to set multiple AND / OR operator in odwek.

[Karthikkumark]

Hi All,

We are using this query to fetch the docuemnt from the Oracle DB.

SELECT      *
FROM       DOCTABA
WHERE       F_DOCCLASSNUMBER in ('1','19')

AND
       A31  =    ?060427090?     

AND
       A120 =    ?ab?       

OR   
       A119 =    ?Q?

Now we need to get the same result when we search in CMOD using ODWEK.
When i tried i found only following code "odFolder.setOrSearchCriteria(false)".  I think this will set AND / OR for entire criteria not for the individual criteria.

Thanks,
Karthik k

[pankaj.puranik]

See this post on a similar topic.

http://odug.net/index.php?topic=963.0