Category Archives: actionscript

SQLite – compare null values

Posted on April 10, 2011 by Łukasz Grela

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

useful use of switch block

Posted on March 24, 2011 by Łukasz Grela

Hi, recently I have browsed through wonderfl.net and found unknown to me but useful use-case of switch block. The switch is selection control block and usually is used as follows:

Posted in actionscript, flash | Tagged , , , | Comments Off on useful use of switch block

SQLError: ‘Error #3132: Data type mismatch’,details:”,operation:’execute’

Posted on February 21, 2011 by Łukasz Grela

Hi, I have noticed weird error: SQLError: ‘Error #3132: Data type mismatch’,details:”,operation:’execute’ this only happens in certain situations, this is how you can reproduce it:

Posted in actionscript, bugs, flash, SQLite3 (in AIR) | Tagged , , , , , | 3 Comments

StyleSheet’s method getStyle doesn’t return null for non-existing style

Posted on January 22, 2011 by Łukasz Grela

I have just learned that getStyle() method of flash.text.StyleSheet class doesn’t return null value when requested style doesn’t exists. Documentation states that it should, but in fact it returns empty object. Which could be fine for tests but you could … Continue reading →

Posted in actionscript, bugs, flash | Tagged , , , , , , , | Comments Off on StyleSheet’s method getStyle doesn’t return null for non-existing style

SQLite: Calculate difference between datetime fields

Posted on January 9, 2011 by Łukasz Grela

If you want to easily get elapsed time between datetime fields in SQLite you may want to take a look at following snippet: Table some_table contains 2 columns named start and finish both datetime type. Result will contain value in … Continue reading →

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