I'm getting this wierd error from sqlite. It only happens when I access this database with Python/APSW. I can access it with sqlite and sqlite3explorer just fine.
>sqlite3 test1.db3 SQLite version 3.1.3 Enter ".help" for instructions sqlite> create table test (id INTEGER PRIMARY KEY AUTOINCREMENT,name text); sqlite> .quit
C:\Documents and Settings\Scott Chapman\My Documents\development\misc\sqlite>python apsw_pragma.py test1.db3
Traceback (most recent call last):
File "apsw_pragma.py", line 37, in ?
dosql(sql)
File "apsw_pragma.py", line 19, in dosql
cursor.execute(query)
apsw.AbortError: AbortError: malformed database schema - near "AUTOINCREMENT": syntax error
Cordially, Scott
