community.borland.com

Article #25313: I/O error for file "c:\temp/iba00206" and sort error

Problem:
Perform a query and get an error or an ibserver access violation
Statement failed, SQLCODE = -902

I/O error for file "c:temp/iba00206"
-Error while trying to read from file
-The device does not recognize the command.

-sort error

Solution:
This is a typical error message received when a customer hits
 this problem of sorting.  This sort error has been logged as
 bug 8349.  This bug has been fixed for InterBase v5.0.

The most common occurrance of this issue is with an order
 by query where the fields being ordered by do NOT have an 
index on them.   This issue is also related to the size of the
 rows being sorted.

WORKAROUND
----------------------------
The workaround for this issue is to define an index on
 the fields that are being ordered by.  Make sure to create
 the appropriate type of index (ascending or descending)
 to match the sort order for the query.

NOTE: For Delphi/C++Builder clients make sure that all
 the queries that the BDE is executing implicitly are also
 taken into account.  The BDE will perform a lot of order by
 queries in order to satisfy the visual database components.


Last Modified: 17-OCT-00