‘unique’ as column name in SQLite table and SQLError

Hi,

I have just learned that “unique” is not a good name for column name when creating table. If you try to use it then you will get following meaningless (at least to me) error:

SQLError: 'Error #3115: SQL Error.', details:'near 'BOOLEAN': syntax error'

So whenever you will have similar error and at first glimpse everything looks fine then check your column IDs.

This entry was posted in actionscript, air for android, flash, SQLite3 (in AIR) and tagged , , , . Bookmark the permalink.