Tag Archives: SQLConection

SQLite – compare null values

Hi, this is a quick post describing issue I have found when using SQLite in flash. I’ve tried to fetch some rows using following snippet, but couldn’t get correct results. Then after digging on the net I have found that … Continue reading

Posted in actionscript, air for android, flash, SQLite3 (in AIR) | Tagged , , , , , , , , , , | 4 Comments

AIR and SQLite transaction issues

Nice thing about SQLite in Adobe AIR are transactions, you start them with begin method of SQLConnection instance and then finish with rollback or commit methods. Problem occurs when you start transaction with default arguments and then try to stop … Continue reading

Posted in actionscript, bugs, flash, SQLite3 (in AIR) | Tagged , , , , , , , , | 1 Comment

SQLite – open and openAsync methods NOT create folders for created database file

If you run into problems with connecting to the database and you are using open or openAsync with CREATE mode then check if folder location exists for your database file, following code will generate SQLError SQLError: ’Error #3125: Unable to … Continue reading

Posted in actionscript, air for android, flash, SQLite3 (in AIR) | Tagged , , , , , , , , | Comments Off on SQLite – open and openAsync methods NOT create folders for created database file