Problem solved with 7.5.0.25 As workaround (but performance loss) set parameter OPTIM_INV_ONLY='NO'
Gert -----Urspr�ngliche Nachricht----- Von: Don Hayes [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 24. M�rz 2005 23:44 An: [email protected] Betreff: AK System error: VAK724 error I get this error when running the query below: S1000(-9404)[MySQL MaxDB][SQLOD32 DLL][MaxDB] General error;-9404 POS(1) System error: AK System error: VAK724 1 (0.02 secs) SELECT REG.primarypatronid, PATRONS.patronlookup, REG.patronid FROM dbo.reg REG INNER JOIN dbo.patrons PATRONS ON REG.primarypatronid=PATRONS.patronid WHERE REG.primarypatronid != 3 AND REG.patronid in (3,103934,99444,102281) AND REG.regstatus != 'V' If I remove the regstatus or the primarypatronid parameters it works OK. It worked as is with 7.5.0.5. Running 7.5.0.24 on Win 32. Don Hayes Database Administrator Tualatin Hills Parks & Recreation District Phone: (503) 614-1219 FAX: (503) 629-5398 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
