Syntax Error in SQL for Crystal Reports 11/Progress 9.1

[jdgreen]

I am getting the following error:

42000:[DataDirect][ODBC PROGRESS driver][PROGRESS]Syntax error (7587) [Database Vendor Code: -20003]

whenever I try to run the following command in CRXI:

SELECT "abs_mstr1"."abs_shipfrom", "abs_mstr1"."abs_par_id", "abs_mstr1"."abs_shipto", "abs_mstr1"."abs_item"
FROM "PUB"."abs_mstr" "abs_mstr1"
WHERE ((("abs_mstr1"."abs_shipto")='MX02PL59') AND (Not ("abs_mstr1"."abs_item")='CTN' And Not ("abs_mstr1"."abs_item")='PLT' And Not ("abs_mstr1"."abs_item")='CT242209' And Not ("abs_mstr1"."abs_item")='00000EXP' And Not ("abs_mstr1"."abs_item")='0CC00091' And Not ("abs_mstr1"."abs_item")='CP4845SP' And Not ("abs_mstr1"."abs_item")='CP4845VL' And Not ("abs_mstr1"."abs_item")='CT241509' And Not ("abs_mstr1"."abs_item")='SB43 R59CD' And Not ("abs_mstr1"."abs_item")='ST35 R59CD' And Not ("abs_mstr1"."abs_item")='ST39 R59CD'));

Any ideas would be greatly appreciated.
John Green


John Green

 

[lbass]

For one thing, your Not() should surround the expression, not the field, as in:

not("table"."field" = 'abc')

Also, you could instead use:

"table"."field" <> 'abc'

-LB