Adobe AIR error #3132

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? 有新文章通知我