Using In Operator in a query

[KETALS]

Hi
I am trying to use \"In\" operator in my query the code is as shown below

Me.Aggregate.PERIOD_END_DATE.Function = MyGeneration.dOOdads.AggregateParameter.Func.Max
Me.Where.PORTFOLIO_ID.Value = dealId
Me.Where.CASH_ACTIVITY_DATE.Operator = MyGeneration.dOOdads.WhereParameter.Operand.LessThanOrEqual
Me.Where.CASH_ACTIVITY_DATE.Value = crntDistDate
Me.Where.CASH_ACTIVITY_TYPE.Operator = MyGeneration.dOOdads.WhereParameter.Conj.AND_
Me.Where.CASH_ACTIVITY_TYPE.Value = \"INITIAL FUNDING,Distribution\"
Me.Where.CASH_ACTIVITY_TYPE.Operator = MyGeneration.dOOdads.WhereParameter.Operand.In_
Me.Query.AddGroupBy(\"PORTFOLIO_ID\")
Me.Query.Load()
Return Me.PERIOD_END_DATE

The query looks somewhat like this in a watch window :

SELECT MAX(\"PERIOD_END_DATE\") AS \"PERIOD_END_DATE\" FROM GENESIS.CASH_ACTIVITY_HEADER WHERE PORTFOLIO_ID = ORTFOLIO_ID1 AND CASH_ACTIVITY_DATE <= :CASH_ACTIVITY_DATE2 AND CASH_ACTIVITY_TYPE IN (INITIAL FUNDING,Distribution) GROUP BY \"PORTFOLIO_ID\"

I am getting following exception : ORA-00936: missing expression

I am not sure why this is happening

Any help is appreciated ?

Thanks
Ketal

[mgnoonan]

If CASH_ACTIVITY_TYPE is a varchar2, then I think you need to enclose your values in quotes:

Code: Select all

Me.Where.CASH_ACTIVITY_TYPE.Value = \"'INITIAL FUNDING','Distribution'\"