The list of extended error codes on http://www.sqlite.org/c3ref/c_abort_rollback.html are in a format that is fairly inconvenient when you're trying to lookup an error value.
Below are what they resolve to, and I'm wondering if perhaps someone could update the page to show those values for future use? Maybe the source could be updated as well? #define SQLITE_IOERR_READ (SQLITE_IOERR | (1<<8)) //256 #define SQLITE_IOERR_SHORT_READ (SQLITE_IOERR | (2<<8)) //522 #define SQLITE_IOERR_WRITE (SQLITE_IOERR | (3<<8)) //778 #define SQLITE_IOERR_FSYNC (SQLITE_IOERR | (4<<8)) //1034 #define SQLITE_IOERR_DIR_FSYNC (SQLITE_IOERR | (5<<8)) //1290 #define SQLITE_IOERR_TRUNCATE (SQLITE_IOERR | (6<<8)) //1546 #define SQLITE_IOERR_FSTAT (SQLITE_IOERR | (7<<8)) //1802 #define SQLITE_IOERR_UNLOCK (SQLITE_IOERR | (8<<8)) //2058 #define SQLITE_IOERR_RDLOCK (SQLITE_IOERR | (9<<8)) //2314 #define SQLITE_IOERR_DELETE (SQLITE_IOERR | (10<<8)) //2570 #define SQLITE_IOERR_BLOCKED (SQLITE_IOERR | (11<<8)) //2826 #define SQLITE_IOERR_NOMEM (SQLITE_IOERR | (12<<8)) //3082 #define SQLITE_IOERR_ACCESS (SQLITE_IOERR | (13<<8)) //3338 #define SQLITE_IOERR_CHECKRESERVEDLOCK (SQLITE_IOERR | (14<<8)) //3594 #define SQLITE_IOERR_LOCK (SQLITE_IOERR | (15<<8)) //3850 #define SQLITE_IOERR_CLOSE (SQLITE_IOERR | (16<<8)) //4106 #define SQLITE_IOERR_DIR_CLOSE (SQLITE_IOERR | (17<<8)) //4362 #define SQLITE_IOERR_SHMOPEN (SQLITE_IOERR | (18<<8)) //4618 #define SQLITE_IOERR_SHMSIZE (SQLITE_IOERR | (19<<8)) //4874 #define SQLITE_IOERR_SHMLOCK (SQLITE_IOERR | (20<<8)) //5130 #define SQLITE_IOERR_SHMMAP (SQLITE_IOERR | (21<<8)) //5386 #define SQLITE_IOERR_SEEK (SQLITE_IOERR | (22<<8)) //5642 #define SQLITE_LOCKED_SHAREDCACHE (SQLITE_LOCKED | (1<<8)) //262 #define SQLITE_BUSY_RECOVERY (SQLITE_BUSY | (1<<8)) //261 #define SQLITE_CANTOPEN_NOTEMPDIR (SQLITE_CANTOPEN | (1<<8)) //270 #define SQLITE_CORRUPT_VTAB (SQLITE_CORRUPT | (1<<8)) //267 #define SQLITE_READONLY_RECOVERY (SQLITE_READONLY | (1<<8)) //264 #define SQLITE_READONLY_CANTLOCK (SQLITE_READONLY | (2<<8)) //520 #define SQLITE_ABORT_ROLLBACK (SQLITE_ABORT | (2<<8)) //516 Doug _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
