take a look at EOSQLQualifier..
EOQualifier is intended for generic qualifications that can be also runing
against an array in memory.
-dave
Darrell Mockus wrote:
> WO 4.0, Oracle 8.0, Java, NT
>
> Hey,
> Does anyone know how to turn the following SQL statement into a
> Qualifier? The Parser really
> doesn't like the "trunc((sysdate-30), 'MONTH')" command.
>
> select * from by_channel where oc_Subscriber_Id=2 AND
> SUBSCRIBER_DATE=trunc((sysdate-30), 'MONTH')
>
> I tried this:
> aQualifier = EOQualifier.qualifierWithQualifierFormat("ocSubscriberId="
> + ocSubscriberId + " AND subscriberDate=trunc((sysdate-30), 'MONTH')" ,
> argumentsArray);
>
> But it would crash when it tried to parse the Qualifier.
>
> I also tried sending in an NSGregorianDate but the NSParser didn't seem
> to like any
> format I tried with it. Againg the NSParser would die on the first '-'
> it saw.
>
> --- Darrell
> --
> --------------------------------------------
> [EMAIL PROTECTED]
