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
 
    