"Mark Brown" <[EMAIL PROTECTED]> wrote: > Hi- > > We have a query that is failing with SQLite error code 10: > > SELECT A, B, C, D, E, F, G > FROM Table1 > WHERE F=? > ORDER BY E > > but succeeds when the ORDER BY clause is removed. > > This database does not have any indicies on any of the tables. Is this why > it is failing? >
When it does not have an index, SQLite sorts by creating a temporary index in a temporary database. The temp database is located in some standard place like /var/tmp. The sqlite3OsTempFileName() backend method names the temp database. Error code to is an I/O error. Likely something is wrong with the temp database file. Maybe the directly is read only or something like that. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------