[SAPDB 7.3.0.29/029-000-087-746 on W2K, DateFormat ISO, rest default] Dear NG, what I really dislike about SAPDB is
S1000: [SAP AG][SQLOD32 DLL][SAP DB]General error;-9111 POS(7261) System error: Move error. This error occured for the second time in my apps (which i have to admit uses complex sql statements). On the first occurence some staff members from sap labs seemed to be interested but I didnt hear anything about it any more. I use visual c++ 6.0 compiled cgi s running on apache server. This is the outline of the statement that caused the above mentioned error: SELECT ...FROM ... WHERE AND ... (lots of ANDs) ... AND ( ... OR NOT EXISTS ( SELECT FROM WHERE AND ... (lots of ANDs) ... AND ( .a<>b..OR .b<>c.. OR .d<>e.. ) )) To my surprise this statement works fine in an interactive environment using SQLStudio. Obviously the memory management of the odbc-driver is part of the problem. But the solution is still more surpring, just use your skills in basic logic: ... ( SELECT FROM WHERE AND ... (lots of ANDs) ... AND NOT ( .a=b..AND .b=c.. AND .d=e.. ) )) So what we have here is a serious optimizer bug. Note that this cgi works without any problem against Oracle 7 - 9, Informix Online and ADABAS-D 6 ;-) Benedikt Wismans University of Bamberg _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
