9/11/2023 0 Comments Sqlite database browser windowsI am using WebKit since I am using Chrome and Safari. Verified by changing the version number and the database didn't open. Var db = openDatabase("c:/users/craig/db/Medical.db","1.0","Medical Database", dbSize) 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. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |