3115 Error with SQLite
Spoiler: Double quote string values in SQLite statements (Possible solution this error is raised by many misconfigurations).
With SQLite in Adobe AIR, I was running some initial tests to figure out a clever TRIGGER to UPDATE or INSERT appropriately.
So far I’ve been writing all my queries in Flex, writing statements manually for instant feedback. I encountered the #3115 Error. Searching through Google I see a lot of posts about this. The answer it seems is widely varied. Other possibilities include incorrect path to applicationStorageDirectory or invalid table names. My issue (to the best of my knowledge) was a reserved word inside single quotes.