Re: [sqlite] update the same record in multiple segments at once

2013-02-28 Thread Pavel Ivanov
On Thu, Feb 28, 2013 at 10:50 PM, Gert Van Assche wrote: > All, I don't know if this is possible. > > A segment in table "Files" contains a record "Content" with a fields like > this "XXX " > Needs to become "XXX 123 456 78 90" > > Based

[sqlite] update the same record in multiple segments at once

2013-02-28 Thread Gert Van Assche
All, I don't know if this is possible. A segment in table "Files" contains a record "Content" with a fields like this "XXX " Needs to become "XXX 123 456 78 90" Based on a "Translation" table were I have |123 |456 |78 |90 If I do UPDATE

Re: [sqlite] "SQLite" Pronunciation

2013-02-28 Thread Ned Fleming
On Thu, 28 Feb 2013 19:21:16 +, Simon Slavin wrote: > >I was once asked whether Ministers of Parliament were shouting "here here" or >"hear hear" and I didn't have a clue. I had to look it up in Hansard. And >even now I know the answer I don't know how the cry

[sqlite] Maybe bug with vtab xDestroy

2013-02-28 Thread Eric Sink
In xRename, if I set zErrMsg and return SQLITE_ERROR, the error message gets through. In xDestroy, using the same code, the error message seems to get eaten. Bug? My code: static int my_Destroy(sqlite3_vtab *tab) { struct my_vtab* pvtab = (struct my_vtab*) tab; if (pvtab->zErrMsg)

Re: [sqlite] Sqlite on windows ce 5.0 Emulator

2013-02-28 Thread Joe Mistachkin
Anand Shah wrote: > > DeviceApplication1.exe > NullReferenceException > at DeviceApplication1.Form1.Button1_Click()\par > at System.Windows.Forms.Control.OnClick()\par > at System.Windows.Forms.Button.OnClick()\par > at System.Windows.Forms.ButtonBase.WnProc()\par > at

Re: [sqlite] sqlite in windows 8?

2013-02-28 Thread Joe Mistachkin
satishpatil14 wrote: > > could anybody guide me how to connect sqlite database connection in windws 8 > app using java script,HTML.please i am trying a lot but in vain > Here you go: http://timheuer.com/blog/archive/2012/08/07/updated-how-to-using-sqlite-from

Re: [sqlite] "SQLite" Pronunciation

2013-02-28 Thread Simon Slavin
On 28 Feb 2013, at 7:02pm, "Jay A. Kreibich" wrote: > On Wed, Feb 27, 2013 at 06:28:03PM -0500, f...@cetussoft.com scratched on the > wall: > >> I guess, to some extent, it may depend on whether one pronounces (or >> mispronounces) "SQL" as "see-kwel" or as "ess-kyoo-ell". >

Re: [sqlite] "SQLite" Pronunciation

2013-02-28 Thread Jay A. Kreibich
On Wed, Feb 27, 2013 at 06:28:03PM -0500, f...@cetussoft.com scratched on the wall: > I guess, to some extent, it may depend on whether one pronounces (or > mispronounces) "SQL" as "see-kwel" or as "ess-kyoo-ell". As I understand it, the "ess-cue-ell" pronunciation is part of the ISO

Re: [sqlite] Memory DB - Query does not return all records after Update

2013-02-28 Thread Igor Tandetnik
On 2/27/2013 1:10 PM, mike.akers wrote: Well, after I made the change I am still seeing the same issue. I added some print statements that will maybe help. What does your select statement look like? What does your update statement look like? Any chance you can show a complete sample that

[sqlite] sqlite in windows 8?

2013-02-28 Thread satishpatil14
could anybody guide me how to connect sqlite database connection in windws 8 app using java script,HTML.please i am trying a lot but in vain -- View this message in context: http://sqlite.1065341.n5.nabble.com/sqlite-in-windows-8-tp67341.html Sent from the SQLite mailing list

Re: [sqlite] Sqlite on windows ce 5.0 Emulator

2013-02-28 Thread Anand Shah
Hi, Thanks for your reply. It is raising below error: DeviceApplication1.exe NullReferenceException at DeviceApplication1.Form1.Button1_Click()\par at System.Windows.Forms.Control.OnClick()\par at System.Windows.Forms.Button.OnClick()\par at System.Windows.Forms.ButtonBase.WnProc()\par at

Re: [sqlite] Memory DB - Query does not return all records after Update

2013-02-28 Thread mike.akers
Oh, nice catch. Well, after I made the change I am still seeing the same issue. I added some print statements that will maybe help. It sounds like you might think it is because I am not closing my statement is the reason I am getting this issue? I was thinking if it were only that then no matter

Re: [sqlite] locked database returning SQLITE_IOERR, not SQLITE_BUSY

2013-02-28 Thread Greg Janee
For the record, this problem went away when I upgraded to the latest & greatest (3.7.15.2). From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Dan Kennedy [danielk1...@gmail.com] Sent: Tuesday, February 26, 2013 10:32 AM