[sqlite] Final preparations for the release of System.Data.SQLite v1.0.94.0 have begun...

2014-09-05 Thread Joe Mistachkin
If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to Monday, September 8th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] Cannot retrieve SQLite Db Data Immediately After Application Startup

2014-09-05 Thread Bob Moran
Thank you guys for the responses. Great info to consider. I was quite confused but the fact that by waiting some length of time after startup of the app, that everything appeared to work. I repeated ran the troublesome call (without stopping the app), and it would work the 6-7 times of making the

Re: [sqlite] Problems uploading CSV into sqlite3 DB

2014-09-05 Thread RSmith
Humour us and paste the first 4 lines or so of your CSV text here On 2014/09/05 04:17, Carlos A. Gorricho (HGSAS) wrote: So, any ideas on how to solve this issue will be more than welcome. I have tried several shortcuts...none works. Latest was to install an Ubuntu 14.04 Virtual Machine

Re: [sqlite] Cannot retrieve SQLite Db Data Immediately After Application Startup

2014-09-05 Thread Nelson, Erik - 2
Bob Moran wrote on: Friday, September 05, 2014 12:07 AM > On Wed, Sep 3, 2014 at 1:29 PM, Nelson, Erik - 2 < > erik.l.nel...@bankofamerica.com> wrote: > > > Bob Moran wrote on Wednesday, September 03, 2014 12:45 PM > > > > > > One added note: My GUI is using QT4, where in this case the SQL > text

Re: [sqlite] sqlite3_step and SQLITE_LOCKED/BUSY

2014-09-05 Thread Simon Slavin
On 5 Sep 2014, at 1:58pm, Jan Slodicka wrote: > 1) SQLITE_OK should not happen. (Official documentation allows /ANY/ result > code. I hope this not true.) > 2) If it happens, then this looks dangerous. You are correct. If you use this routine only for SELECT commands or

Re: [sqlite] sqlite3_step and SQLITE_LOCKED/BUSY

2014-09-05 Thread Jan Slodicka
Thanks, Simon, perhaps I did not formulate may question clearly enough. The class of course works as you wrote, the only problem relates to the error handling. If you are interested, the C# wrapper (original code) is here

Re: [sqlite] Cannot retrieve SQLite Db Data Immediately After Application Startup

2014-09-05 Thread Alessandro Marzocchi
Another solution would be moving the call to qprintable inside the prepare_v2 call: sqlite3_prepare_v2( db, qPrintable(qstr) , qstr.length()+1, , NULL) I don't know if this is your case but please note that I think this way would not handle well some Unicode strings (the ones for which utf8 and

Re: [sqlite] Cannot retrieve SQLite Db Data Immediately After Application Startup

2014-09-05 Thread Alessandro Marzocchi
You could use QString::constData which returns a pointer to internal data to the string encoded in utf16 and then change the call to sqlite3_prepare16_v2... Il 05/set/2014 06:08 "Bob Moran" ha scritto: > Erik, > Are you implying that I must copy the text returned by