Category Archives: actionscript

AIR and SQLite transaction issues

Posted on January 5, 2011 by Łukasz Grela

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

‘unique’ as column name in SQLite table and SQLError

Posted on November 27, 2010 by Łukasz Grela

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.’, … Continue reading →

Posted in actionscript, air for android, flash, SQLite3 (in AIR) | Tagged , , , | Comments Off on ‘unique’ as column name in SQLite table and SQLError

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

Posted on November 17, 2010 by Łukasz Grela

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

AIR for Android with FlashDevelop

Posted on October 20, 2010 by Łukasz Grela

Hi, I have been playing with AIR for Android lately but I could do it only from Flash CS5, recently I have found that my embedded fonts wasn’t displayed in the android application, after further investigation it was Flash CS5 … Continue reading →

Posted in actionscript, android, flash | Tagged , , , , , , , , , | Comments Off on AIR for Android with FlashDevelop

Rectangle with “sorted” edges

Posted on October 14, 2010 by Łukasz Grela

In some situation you would like to reassure that given Rectangle object have “top-down, left-right” order you can do it using following two snippets this creates “normalized” copy of the given rectangle this modifies given rectangle directly

Posted in actionscript, flash | Tagged , , | Comments Off on Rectangle with “sorted” edges