Re: [sqlite] Question about multi-threading with a read-onlydatabase

Mohit Sindhwani wrote: > On 29/5/2012 10:52 AM, Igor Tandetnik wrote: >> That document is obsolete. It has been safe for a long time now. For >> details, see http://www.sqlite.org/threadsafe.html > > Thank you very much. However, reading this page also, it says: > >>

Re: [sqlite] Question about multi-threading with a read-only database

Hi Igor, On 29/5/2012 10:52 AM, Igor Tandetnik wrote: Mohit Sindhwani wrote: However, looking at this: http://www.sqlite.org/cvstrac/wiki?p=MultiThreading It has never been safe to use the same database connection simultaneously in multiple threads. That document is

Re: [sqlite] Question about multi-threading with a read-only database

Mohit Sindhwani wrote: > However, looking at this: > http://www.sqlite.org/cvstrac/wiki?p=MultiThreading > > It has never been safe to use the same database connection simultaneously in > multiple threads. That document is obsolete. It has been safe for a long time now. For

[sqlite] Question about multi-threading with a read-only database

Hi All, We have a read-only database (compiled with CEROD) that needs to be accessed from within the same program using multiple threads. Currently, we open the database once and all the threads use the sqlite3_db* to create their own personal prepared queries and run their queries.

Re: [sqlite] Update Query

On 29 May 2012, at 1:16am, IQuant wrote: > I may try a 2 pass approach: Pass 1 update query to record the rowid > of the previous symbol record and pass 2 use a join for performing the > IQ calcs. Yep. Just do it in your programming language. One SELECT to find the

Re: [sqlite] Update Query

Not sure how to combine the subqueries. Our TickData table looks close to: TimeStamp, Symbol, Ask, Bid, Last ... IQ_A, IQ_B, IQ_T, IQ_X We need to update the IQ fields with calculations always made between the current record and previous symbol record ordered by timestamp. I don't know how to

Re: [sqlite] FW: Problem with SQLite when deployed.

Peter, I'm not sure if this will help but I had exactly the same error but only on some Vista and XP installations. After much research I found that VC 2010 runtime support was missing from these PCs. If this is the same as your problem then you can either try one of the SQLite statically

Re: [sqlite] FW: Problem with SQLite when deployed.

On Friday, my when I ran the install routine and everything was installed on my 32-bit OS, it did not work properly. Then I manually copied the SQLite.Interop.dll over to the 32-bit OS, and it worked. However, when I included this file in the install program it did not work. Now I am unable

Re: [sqlite] FW: Problem with SQLite when deployed.

Are you saying that you can manually place the dlls and exes on different computers and have it work? regards, Adam On Mon, May 28, 2012 at 7:36 AM, Peter Walburn wrote: > Okay, I've tried everything I can think of to get this to work. I've been > at it for 4

Re: [sqlite] FW: Problem with SQLite when deployed.

Okay, I've tried everything I can think of to get this to work. I've been at it for 4 days now!! I know that it is possible, because it did run on the 32-bit XP system that I was running my installation on - that's when I copied the 32-bit SQLite.Interop.dll from the 64-bit OS to the 32-bit

Re: [sqlite] FW: Problem with SQLite when deployed.

I thought that things were going to work ok on Friday, but now that my Install routine copies the 32-bit DLL files onto the 32-bit operating system, I am receiving the same errors. Installing the application (using the same install routine) on a 64-bit operating system does work fine. This