-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: den 3 december 2002 14:48
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] unknown win32 error 22


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


[Jenny Sigvardsdotter]
Hi!
Helen: Thanks for your reply.
BATCHID is not primary key but yes BATCHDATUM is Date. Both of them occur
many times in the table so I do want to group them.

I would guess that
SELECT distinct(BATCHID), BATCHDATUM
FROM AKTKONTO
WHERE BATCHKOD = 1
AND NOT BATCHID IS NULL

would do the same thing maybe as my group by. But I am afraid that the
problem is somewhere else. Do you know why this error can occurr? what has
the temp directory has to to with it?

regards,
Jenny


[Non-text portions of this message have been removed]