I am trying to create a table adapter that contains a case when and IN clauses, see below:
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.
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.