Which leaves us with a sort of frustrated emptiness. "Oops, PL-X on Dingdong works different than I thought - Soz for the noise." "It says: have you tried doing a, b or c?" "what does it do when you run *#&%#("ver") ?" "It runs on OS Dingdong on a Jimbo-Pro PC."Īnd (from some reader who happens to know PL-X): "Really? what platform do you use? How do you ask it?" "Hi Guys, my SQLite doesn't work because when I ask it for x y and z, I get nothing/badness." You can find tons of discussions on the forum of the form: If we have to shake the box like a christmas gift to try and guess what is inside, it ends in frustration usually.įurther to this, it's almost never SQLite that is broken, so to try and help, us SQLiters have to start a guessing procedure about the target platform. #Root db sqlite browser full#If we have full information, helping you becomes trivial and pleasurable. We rely on your very full description of every little detail to try and grasp it. With regards to your project, we are as novice as you, we have no clue. I have accessed the database thru JS but can't get a transaction to work.įirstly, it's perfectly OK being a novice, that's how we all start, but you are making one very typical rookie mistake: Thinking that the rest of us know what's going on. 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. Tx.executeSql('SELECT id,Name,Relationship,Age FROM Family', , Tx.executeSql('INSERT INTO Family (id,Name,Relationship,Age) VALUES(2,"EFGHi","Wife",01)') Īlert('Table created and rows inserted') Tx.executeSql('INSERT INTO Family (id,Name,Relationship,Age) VALUES(1,"ABCD","Husband",00)') Tx.executeSql('create table IF NOT EXISTS Family (id unique, Name text, Relationship text, Age integer)') The columns 1 and 2 are added and get populated. #Root db sqlite browser code#The error code that I am getting with the below code is 5. I am also trying to get the error messages to print correctly. I think I have the table created correctly but not sure, I am still working on that. I am now trying to insert and print three columns in each row. I have verified this by using DB Browser. I can add records and select the records and print them out, but the database in the code path has more data in than what I am adding. I have identified most of my problems and fixed them, they were with my code. I 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. #Root db sqlite browser windows 10#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. #Root db sqlite browser 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. #Root db sqlite browser update#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 |