INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...This site is a great forum to exchange knowledge..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Progress Software: PROGRESS Forum

Syntax Error in SQL for Crystal Reports 11/Progress 9.1

Read More Threads Like This One

jdgreen (TechnicalUser)

10 Sep 09 14:10

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

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Progress Software: PROGRESS