From: Don Hayes (dhayesthprd.com)
Date: Thu Mar 24 2005 - 16:44:12 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]