It worked for me: Instead of this:
SQLMem.ExecNonQuery("CREATE TABLE MEMTABLE(MN INT, QTY INT, VAL REAL)")
use this where Val is TEXT:
SQLMem.ExecNonQuery("CREATE TABLE MEMTABLE(MN INT, QTY INT, VAL TEXT)")
In all cases I got:
** Service (starter) Destroy (ignored)**
*** Service (starter) Create ***
** Service (starter) Start **
** Activity (main) Create, isFirst = true **
** Activity (main) Resume **
Total : 1.949371083E9
Formated : 1,949,371,083
Val : 102816133
Val : 7520827
Val : 779800
Val : 1398405025
Val : 58862578
Val : 380986720
Formated2 : 1,949,371,083