Adobe AIR error #3132

17 sec read

You may get this error:

could not convert text value to numeric value.
Error #3132: Data type mismatch.

People have discussed this error related to date column. Here is another case where this error could happen: when a column in sqlite is BIGINT and what you insert is “” (empty string). The solution is simple, simply replace “” with 0.

// You will get #3132 error
statement = "INSERT INTO t (c) VALUES (:v)";
para[":v"] = "";
// Replace empty string with 0 and you will be fine
para[":v"] = 0;


Want to receive new post notification? 有新文章通知我

How much money did I make from an app?

Undoubtedly some people are very successful in making money by developing a smartphone app. Back in 2012 I developed an app called “Handbook of Brain” which is a collected resources of brain anatomy, function and diseases. I put the app i
Xu Cui
27 sec read

Handy programs to visualize NIRS data (2): plotTopoMap

Often you need to view the spatial pattern of activation as in the example below. plotTopoMap allows you to do that. It probably only works for Hitachi devices where the spatial relationship between channels are known. In the above example, the activ
Xu Cui
37 sec read

Flash 3D video demo

Racer Ostrova Zombie
Xu Cui
0 sec read

Leave a Reply

Your email address will not be published. Required fields are marked *