I have a simple form in a jsfiddle here: http://jsfiddle.net/atma88/6zx415bo/
The problem is that it doesn't delete the record it adds.
I add list item with call to the javascript deleteRecord like this:
function showRecords() {
results.innerHTML = '';
db.transaction(function(tx) {
tx.executeSql(selectAllStatement, [], function(tx, result) {
dataset = result.rows;
for (var i = 0, item = null; i < dataset.length; i++) {
item = dataset.item(i);
results.innerHTML += '<li>' + item['lastName'] + ' , ' + item['firstName'] + ' <a href="#" onclick="loadRecord(' + i + ')">edit</a> ' + '<a href="#" onclick="deleteRecord(' + item['id'] + ');">delete</a></li>';
}
});
});
}
My delete record function looks like this:
function deleteRecord(id) {
alert('it deleted');
db.transaction(function(tx) {
tx.executeSql(deleteStatement, [id], showRecords, onError);
});
resetForm();
}
When I click the delete link I get the javascript error: Uncaught ReferenceError: deleteRecord is not defined