At 01:52 PM 03-12-02 +0100, you wrote:

>Hello!
>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?
>
>I believe this is an Interbase error. Has anyone seen it before?
>I use interbase 5.6.

If BATCHID is the primary key and BATCHDATUM is a v.5.6 DATE type, then
wouldn't your query return all unique values for both columns? If so, they
could not be grouped. Perhaps you really want to use ORDER BY?

heLen