Jenny Sigvardsdotter wrote:

> I get this strange errormessage when I run a query "Unsuccessful execution
> caused by a system error that precludes successful execution of susequent
> statements. I/O error for file "c:\winnt\temp\iba02432" Error while trying
> to write to file. Unknown win32 error 22"
> This error occurs when I try to use my sql statement via my
> Delphiapplication using quickreport as well as when I just execute the
> sql-statement in IBAdmin.
> The statement is
> "SELECT BATCHID, BATCHDATUM
> FROM AKTKONTO
> WHERE BATCHKOD = 1
> AND NOT BATCHID IS NULL
> GROUP BY BATCHID, BATCHDATUM"
> If I remove group by everything is ok. Why?

What do you want to achieve? Maybe you want something like:
select BATCHID, BATCHDATUM, count(*)
from AKTKONTO
where BATCHKOD = 1
and not BATCHID is Null
group by BATCHID, BATCHDATUM


--
Aage J.