Re: Error -640: QPLAN sanity faiure (1503.0)

Richard Spitz (spitz@GANS2X.ana.med.uni-muenchen.de) wrote: RS> I just upgraded from Online/Star 5.01 to 5.03, and now I suddenly RS> encounter the above error in a 4GL program which had been running RS> without a glitch for years! I have experienced the same error upgrading from SE 5.01 to 5.03. It seems due to some incompatibility on stored procedures 'created' by 5.01 engine, and 'executed' by 5.03. Simply dropping and re-creating stored procedures and triggers with 5.03 engine I have solved my problem about -640 error. RS> The error occurs after the following piece of code: RS> RS> BEGIN WORK RS> DELETE FROM vertrag RS> WHERE stellennr = aend.stellennr RS> AND v_begin = aend.v_begin RS> AND persnr = pnr If your delete statement is trigger/stored_procedure related, that above may be the solution. Hope this helps. o ___*____ e-mail Ciao! \\ _\\/^\\ _ | |_ <joefor@iperv.it> .. ... ....(_)=>#(_) (_|oe |or padova -- italy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~