PRELIMINARY – Websql CRUD with Custom List Example

Please use the MobiOne 2.5 milestone-2 and ONLY run this example in the Mobile Web Simulator. My original post included a note that explicitly called out avoiding use of the Test Center. See the note above. Also there is a small glitch as identified by @nvts above but this example still runs. Note that I qualified this version as preliminary and made it available to address an immediate request by a user for such an example. The minor glitch will be resolved in the upcoming MobiOne 2.5 milestone-3 version planned to be released late next week.

>can you also answer me other part of the post about the database connection?

All of the db code can be found in the list-db.js file. Crack it open and give it a look.

/**
 * create 'list-demo' database and ITEMS table
 */  
function initDatabase() { 
    if (!window.openDatabase) {
        $('[id$=errorTxt').text('Web SQL not supported on this device');
        return;
    }
    
    db = openDatabase('list-demo', '1.0', 'repository for list items', 1024 * 1024);
    console.log('db created');
    
    db.transaction(function(tx) {
      tx.executeSql('CREATE TABLE IF NOT EXISTS items (' +
              'id INTEGER PRIMARY KEY AUTOINCREMENT,' + 
              'item TEXT)');
      console.log('tabled created');      
    });    
}

Looks like you are running this example in the old Test Center. Is this correct?
If yes, try this example using the Mobile Web Simulator (see Windows menu>Settings>Simulator).