Question TableAdapter query error (IN clause)

dsk96m

Well-known member
Joined
Jan 11, 2013
Messages
173
Programming Experience
1-3
I am trying to create a table adapter that contains a case when and IN clauses, see below:
VB.NET:
SELECT        CATSCOUNTE, PABRJ AS FYR, PABRP AS PP, PERSNO AS EMPL_ID, PNALT AS EMP_NO,
         CASE 
             WHEN SUBSTR(lstar,1,3) IN ('LAD','LIN','IDR') THEN 'Z' 
                  ELSE SUBSTR(ztmtypcd,1,1) 
             END TC
FROM            FSET.TCATMSTR
WHERE        (RPABRJ = :Year) AND (RPABRP = LPAD(:PP, 2, '0')) AND (PERSNO = :EmplID)

When I try to finish the wizard I get an error:
"Error in list of values in IN clause. Unable to parse query text."

I can hit ok, and preview the data and it works just fine, but the fields dont show up in the list of field for the adapter. TC in the example above.

What do I need to do to correct this. Thanks for the help.
 
Top Bottom