Tag Archives: SQLite

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

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

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

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