topic Re: Where... IN returning an error in QlikView

Where... IN returning an error

Sun, 12 May 2013 23:52:20 GMT

Hello,

Can anyone help with the reason why I'm getting the error message:

SQL##f - SqlState: 37000, ErrorCode: 8258, ErrorMsg: [Jade Software Corporation][JADE ODBC Server] Expecting: 'comparison operator'; found 'IN' at 60

SQL SELECT *

FROM HRLeaveRequest

WHERE myHRLeaveRequestStatus IN('02162.0000000600','02162.0000000601','02162.0000000604')

When I run the following script:

LOAD

       calculatedDays,
     calculatedHours,
     dateFrom,
     dateTo,
     enteredLeave,
     approvalLastAction,
     myHRPerson,
     myHRTransTypePay as TransType,
     cancelReason,
     myHRLeaveRequestStatus;

SQL SELECT *

FROM Table_Name

WHERE myHRLeaveRequestStatus IN('02162.0000000600','02162.0000000601','02162.0000000604');

Regards

Re: Where... IN returning an error

Gysbert_Wassenaar — Mon, 13 May 2013 07:06:08 GMT

Make sure there's a space between IN and ('02162.000....

If that does not work check that Jade (and/or its odbc driver) supports the where in ... syntax

Re: Where... IN returning an error

Thu, 23 May 2013 01:08:39 GMT

Thank you both,

I think it is a problem with Jade not accepting the where in... syntax.

I've just used a AND instead.

Thanks again.

Cristina

Re: Where... IN returning an error

Sokkorn — Thu, 23 May 2013 01:15:35 GMT

Hi Cristina,

Have you try this one yet:

LOAD

calculatedDays,

calculatedHours,

dateFrom,

dateTo,

enteredLeave,

approvalLastAction,

myHRPerson,

myHRTransTypePay as TransType,

cancelReason,

myHRLeaveRequestStatus Where Match(myHRLeaveRequestStatus,'02162.0000000600','02162.0000000601','02162.0000000604');

SQL SELECT *

FROM Table_Name;

Regards,

Sokkorn

Re: Where... IN returning an error

Thu, 23 May 2013 01:28:58 GMT

Thank you Sokkorn,

I have just tested it and it works. Although I've sorted it out with an AND which is working as other conditions have to be met, it will be very useful in other scripts I need to set up for quering data in Jade.

thanks

fcrysss