Re: [sqlite] Adobe Air - Using SQLite db, cannot UPDATE nor INSERT

It may make little REAL difference, but the SELECT statement you show does not have a semicolon at the end, but the INSERT statement does. Perhaps the error returned is misleading? -- George Eckert On Tuesday, November 15, 2011 at 6:09 PM, BertD wrote: Hello all, Question : I'm

[sqlite] Export Blob data from sqlite database to html

I have a sqlite database from a iphone chat app which I would like to present in a human readable format either csv, html or other. The database has over 600 tables with multiple rows of conversation, the fields are: sender (text) - servertime (blob) – localtime (blob) – type (text) – data(blob)

[sqlite] 200 lines of fun sqlite3 code

200 lines of code with embedded c. (headers omitted) This code comes up and reads triples from a table view called self, reads triples one at a time. The triples are either a configure and load sql statement command, or the triple is executed, as a random sql procedure doing whatever, Rinse and

Re: [sqlite] 200 lines of fun sqlite3 code

Please submit code to pastebin.com or similar. 2011/11/16 Matt Young youngsan...@gmail.com: 200 lines of code with embedded c. (headers omitted) This code comes up and reads triples from a table view called self, reads triples one at a time.  The triples are either a configure and load sql

Re: [sqlite] Adobe Air - Using SQLite db, cannot UPDATE nor INSERT

George Eckert wrote: It may make little REAL difference, but the SELECT statement you show does not have a semicolon at the end, but the INSERT statement does. Perhaps the error returned is misleading? -- George Eckert I've not checked if that would be a problem, i'll check it

Re: [sqlite] Adobe Air - Using SQLite db, cannot UPDATE nor INSERT

// first we need to set the file class for our database (ICM.db).    var db:File = new File (C:/ICM.db); Depending on your Windows version only users with elevated privileges could be able to write into root C:\ directory. Adobe Air apparently won't ask you to elevate its privileges just to

Re: [sqlite] Adobe Air - Using SQLite db, cannot UPDATE nor INSERT

Pavel Ivanov-2 wrote: // first we need to set the file class for our database (ICM.db).    var db:File = new File (C:/ICM.db); Depending on your Windows version only users with elevated privileges could be able to write into root C:\ directory. Adobe Air apparently won't ask you to

Re: [sqlite] Export Blob data from sqlite database to html

On 16-11-2011 10:02, si666 wrote: I have a sqlite database from a iphone chat app which I would like to present in a human readable format either csv, html or other. you should ask the author of that iphone app ;) ___ sqlite-users mailing list