Hi,
I use the latetst Appbuilder extension (V. 2015.4.1127.4), Cordova version 3.7.0 and additional plugin Brodysoft SQLitePlugin 1.0.6. (installed via Plugins Marketplace).
I've developed an app with the Kendo mobile UI and all functions works on Apple and Android devices (via Building in Cloud in the Appbuilder-menu) just fine. Only storing records on a WP8.1 device doesn't seem to work.
I debugged the app step-by-step and finally at the 'onSucces' and 'onError' -handling of the database-transaction I've put some alerts to show me (on the device)what event fires up. The 'onSucces'-event fires up and the value of the internal 'insertId'-variable changes. Only the value of the recordcount-variable is 0 all the time. Even I do an another insert-transaction.
What can I do to function this on WP8.1 like the other type of devices (Apple, Android) ?
With regards,
Gilbert van Veen
Piece of code I used to debug the transaction:
function insertRecord(_a, _b, _c, _d, _e, _f, _g, _h, _i, _j) {
app.db.transaction(function (tx) {
tx.executeSql("INSERT INTO mytable (a, b, c, d, e, f, g, h, i, j, added_on) VALUES (?,?,?,?,?,?,?,?,?,?,?)",
[
_a,
_b,
_c,
_d,
_e,
_f,
_g,
_h,
_i,
_j,
new Date()
],
function (tx, res) { alert(res.insertId); alert(res.rows.length); }, // onSucces
function (e) { alert("ERROR: " + e.message); } // onError
);
});
}