"无法读取属性'消息'未定义的“;在WebSQL错误回调中
"Cannot read property 'message' of undefined" in WebSQL error callback
我的代码:
function onSuccess(transaction, resultSet) {
console.log('Query completed: ' + JSON.stringify(resultSet));
}
function onError(transaction, err) {
console.log("Error : " + err.message);
}
function createTBinventorymastercatalogue(tx) {
var query = "";
query += "CREATE TABLE IF NOT EXISTS INVENTORY_MASTER_CATALOGUE(SysPk_InvtyCat,SysFk_Invty_InvtyCat);";
tx.executeSql(query, [], onSuccess, onError);
tx.executeSql("INSERT INTO INVENTORY_MASTER_CATALOGUE(SysPk_InvtyCat, SysFk_Invty_InvtyCat) VALUES (?,?)", ['dummydata-pk', 'dummydata-fk'], onSuccess, onError);
}
这是我的JavaScript控制台中的内容:
查询已完成:{}
查询已完成:{}
未捕获的类型错误:无法读取未定义的属性"message"
完成了两个查询,所以我想它成功地创建并插入了。当我尝试显示它们时,数据就会显示出来。
但是,它不应该显示{}
内部的一些数据吗?
我不知道为什么我得到:
未捕获的类型错误:无法读取未定义的属性"message"
即使数据被插入。上面的2个查询是应用程序启动时唯一运行的查询。
我还有其他查询,但它们只在单击按钮时运行,所以错误不可能是由这些查询引起的。我不知道第三个日志来自哪里,为什么"消息"是未定义的?
MCVE
JavaScript:
var ref = null;
(function () {
"use strict";
document.addEventListener( 'deviceready', onDeviceReady.bind( this ), false );
})();
var dbSize = 5 * 1024 * 1024; // 5MB
var db = openDatabase("Todo", "", "Todo manager", dbSize, function () { console.log('db successfully opened or created');});
db.transaction(createTBinventorymastercatalogue, onSuccess, onError);
function onSuccess(transaction, resultSet) {
console.log('Query completed: ' + JSON.stringify(resultSet));
}
function onError(transaction, err) {
console.log("Error : " + err.message);
}
function createTBinventorymastercatalogue(tx)
{
var query = "";
query += "CREATE TABLE IF NOT EXISTS INVENTORY_MASTER_CATALOGUE(SysPk_InvtyCat,SysFk_Invty_InvtyCat);";
tx.executeSql(query, [], onSuccess, onError);
tx.executeSql("INSERT INTO INVENTORY_MASTER_CATALOGUE(SysPk_InvtyCat, SysFk_Invty_InvtyCat) VALUES (?,?)", ['dummydata-pk', 'dummydata-fk'], onSuccess, onError);
}
function renderinventorymastercatalogue()
{
alert('rendering');
db.transaction(function (tx2) {
tx2.executeSql('SELECT * FROM INVENTORY_MASTER_CATALOGUE', [], showInventoryMasterCatalogueData, onSuccess, onError);
});
}
function showInventoryMasterCatalogueData(tx,results) {
var invtritemsstring = '';
for (var ind = 0; ind < results.rows.length ; ind++)
{
invtritemsstring += results.rows.item(ind).SysPk_InvtyCat + '-' + results.rows.item(ind).SysFk_Invty_InvtyCat + '<br/>';
}
$('.Data-cont').html(invtritemsstring);
}
$('body').on('click', '#show-invtycatmstr-btn', function () { renderinventorymastercatalogue(); });
function deleteAllFromInventoryMasterCatalogue()
{
alert('delete from table');
db.transaction(function (tx3) {
tx3.executeSql('Delete from INVENTORY_MASTER_CATALOGUE', [], renderinventorymastercatalogue, onError);
});
}
$('body').on('click', '#deleteallfrominvtycatmstr-btn', function () { deleteAllFromInventoryMasterCatalogue(); });
function insertdata(tx)
{
var enteredsyspk = $('#syspk-inputtext').val();
var enteredsysfk = $('#sysfk-inputtext').val();
db.transaction(function (tx4, enteredsyspk, enteredsysfk)
{
alert(enteredsyspk + ' ' + enteredsysfk);
tx4.executeSql('INSERT INTO INVENTORY_MASTER_CATALOGUE(SysPk_InvtyCat, SysFk_Invty_InvtyCat) VALUES (?,?)', ['enteredsyspk', 'enteredsysfk'], renderinventorymastercatalogue, onError);
});
}
$('body').on('submit', '#syspksysfk-form', function (event)
{
event.preventDefault();
insertdata();
});
html:
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta http-equiv="Content-Security-Policy" content="default-src 'self' data: gap: https://ssl.gstatic.com 'unsafe-eval'; style-src 'self' 'unsafe-inline'; media-src *">
<title>BlankCordovaApp3</title>
</head>
<body>
<div id="content-container">
<form id="syspksysfk-form">
<input type="text" name="syspk" id="syspk-inputtext" value="" required/>
<input type="text" name="sysfk" id="sysfk-inputtext" value="" required />
<br />
<input type="submit" value="submit" id="submitform-btn" />
</form>
<br />
<button id="show-invtycatmstr-btn">Show InvtyCatMstr</button>
<button id="deleteallfrominvtycatmstr-btn">Delete All From InvtyCatMstr</button>
<div class="Data-cont"></div>
</div>
<script src="scripts/jquery-2.1.4.min.js"></script>
<!-- Cordova reference, this is added to your app when it's built. -->
<script src="cordova.js"></script>
<script src="scripts/platformOverrides.js"></script>
<script src="scripts/index.js"></script>
调用db.transaction()
:时,成功/错误回调被反转
db.transaction(createTBinventorymastercatalogue, onSuccess, onError);
由于某种原因,该方法首先进行错误回调。
交换它们,一切都很好:
var dbSize = 5 * 1024 * 1024; // 5MB
var db = openDatabase("Todo", "", "Todo manager", dbSize, function() {
console.log('db successfully opened or created');
});
db.transaction(createTBinventorymastercatalogue, onError, onSuccess);
function onSuccess(transaction, resultSet) {
console.log('Query completed: ' + JSON.stringify(resultSet));
}
function onError(transaction, err) {
console.log("Error : " + err.message);
}
function createTBinventorymastercatalogue(tx) {
var query = "";
query += "CREATE TABLE IF NOT EXISTS INVENTORY_MASTER_CATALOGUE(SysPk_InvtyCat,SysFk_Invty_InvtyCat);";
tx.executeSql(query, [], onSuccess, onError);
tx.executeSql("INSERT INTO INVENTORY_MASTER_CATALOGUE(SysPk_InvtyCat, SysFk_Invty_InvtyCat) VALUES (?,?)", ['dummydata-pk', 'dummydata-fk'], onSuccess, onError);
}
相关文章:
- 测试Angular Service解决错误回调中的promise
- $http服务未触发成功或错误回调
- jQuery AJAX错误回调未运行
- JavaScriptajax请求servlet调用错误回调函数
- 为什么 AJAX 完成和错误回调都触发了
- Cordova Android短信插件不会触发成功或错误回调
- 无法识别错误回调
- 在第一次错误回调时退出承诺链
- 如何获取 Ember 组件对象内部承诺成功或错误回调
- 在 Node.js 中传播错误回调,并避免所有额外的麻烦
- 在 HTTP 错误回调中访问“this”
- 在 AngularJS 中声明一个承诺,并带有命名的成功/错误回调
- 谷歌浏览器中的地理位置错误回调
- PhoneGap 3.0.0 Tanelih 蓝牙插件在 Android 上已启用错误回调不起作用
- $http错误回调不能与 httpProvider responseInterceptor 结合使用
- JayData 上的默认错误回调
- 错误回调中的错误:TestPlugin2 = 引用错误:找不到变量:在 file:///android_asset/ww
- 主干.js:保存方法始终返回错误回调
- AJAX 中的成功或错误回调不起作用
- Backbone.js:奇怪的.save()错误回调