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