Hi, I am new with SAP DB, but I found a problem: When I am executed following query: SELECT FROM IndexQueue WHERE Car_Id <= 900 AND Car_Id IN (SELECT Card.Car_Id FROM Card, DtdForDivision WHERE Int_Id = 2 AND Dii_Id = Dii_DivisionId)
I received error: [SAP AG][SQLOD32 DLL][SAP DB]General error;-9111 POS(1) System error: Move error. I found that this error is caused by sub query, no matter what there is, eg: SELECT FROM IndexQueue WHERE Car_Id <= 900 AND Car_Id IN (SELECT Card.Car_Id FROM Card) This situation exists, when column Car_Id from IndexQueue has no primary key (even if index exists). This problem disappeared when I created primary key for Car_Id column. I am using ODBC driver 7.04.03.00 on W2000 Pro SP3 Regards Michal Wojcik P.S. This query works fine on MS SQL Server, MS Access and IBM DB2 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
