The code below is what I am trying to get to work but am at a complete loss.Īny help would be greatly appreciated. The database contains 1 row and was built and populated using the DB Browser for SQLite tools. The var db contains the version of the database so I am assuming it has been found and is open. I have a breakpoint on the first function statement but that appears to be the failing point. I have accessed the database thru JS but can't get a transaction to work. I apparently don't understand everything that I am trying to do. I am new to SQLite, webkit and all of the other access methods. I have placed the database in C:/Users/craig/My1stdb.db on a windows 10 system.
I am sorry for not responding sooner but being retired has some advantages. Tx.executeSql('SELECT * FROM foo',, function (tx, results)Īlert((i).text+ ' Row: '+i) Tx.executeSql('insert into foo (id, text) values (2, "testme")') Tx.executeSql('INSERT INTO foo (id, text) VALUES (1, "synergies")') Tx.executeSql('CREATE TABLE IF NOT EXISTS foo (id unique, text)') but I can't find it there.Īny help would b greatly appreciated. I now that this should go in C:/users/craig/workspace/. Below is the code that I am using to open/ create the database. I have tried specifying a directory but it doesn't appear there.
CANT DRAG DB.SQLITE3 TO DB BROWSER FOR SQLITE MANUALS
I have copied and example from one of the online manuals and it appears to work, but I can't find the location of the database. I have a web page written where I am trying to update an SQLITE database using JAVASCRIPT and WebKit. I am new to SQLite but have some knowledge of SQL.
0 kommentar(er)
