--- In firebird-support@yahoogroups.com, "Mahmut Akbolat"
<mahmut.akbolat@...> wrote:

>
> Day is good!
>
> No one will prompt in what it can be error! it works normally,

while in one client this error crawls out.

> Executed sql is like that
>
> SELECT DISTINCT A.FIELD1
> FROM TABLE1 A
> JOIN TABLE2 B ON B.FIELD2 = A.FIELD2
> JOIN TABLE3 C ON C.FIELD3= B.FIELD3
>
> And version is Firebird1.5
>
> Error message :
>
> General SQL error.
> I/O error for file "D:\WINDOWS\TEMP\fb_merge_6o7jgt"
> Error while trying to write to file
>

Firebird is sorting A.Field1 so it can return distinct.

Is there enough disk space free on D: ?
Any other problems with the hard drive?

Adam