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:
Continue reading
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 have a style with empty declaration block which would create false positive result. This error appears to be for some time, check screen grabs from different players starting from fp9.
Continue reading
If you want to easily get elapsed time between datetime fields in SQLite you may want to take a look at following snippet:
SELECT
cast(
(
strftime('%s',t.finish)-strftime('%s',t.start)
) AS real
)/60/60 AS elapsed
FROM some_table AS t;
Table some_table contains 2 columns named start and finish both datetime type. Result will contain value in hours.
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 it without any changes being made.
Continue reading