Re: [sqlite] Concurrence in DB - again

2004-03-07 Thread Peter
Thiago Mello wrote: Yes, in my callback() functions I have some sqlite_exec() functions. How I can avoid this? Well you have to rewrite your code, store the complete result of one query before calling sqlite_exec* again. You can probably achieve a similar result with some SQL wizardry, but I hav

Re: [sqlite] Concurrence in DB - again

2004-03-07 Thread D. Richard Hipp
Thiago Mello wrote: Yes, in my callback() functions I have some sqlite_exec() functions. How I can avoid this? It is safe to call sqlite_exec() from within a callback. By "safe" I mean that you should never get back an SQLITE_MISUSE. But if you are trying to use an inner sqlite_exec() to modify

Re: [sqlite] Concurrence in DB - again

2004-03-07 Thread Thiago Mello
Yes, in my callback() functions I have some sqlite_exec() functions. How I can avoid this? Thanks, Thiago Em Dom, 2004-03-07 às 15:10, Peter escreveu: > Thiago Mello wrote: > > about the sqlite_compile(), Im using simple call back function. > > Are you calling any other sqlite_* function with

Re: [sqlite] Concurrence in DB - again

2004-03-07 Thread Peter
Thiago Mello wrote: about the sqlite_compile(), Im using simple call back function. Are you calling any other sqlite_* function within the callback? Doing that will probably get you the "call out of sequence" error. Regards P. -

Re: [sqlite] Concurrence in DB - again

2004-03-07 Thread Thiago Mello
Hi Arnaud, Now I in all sqlite_exec functions my nanosleep() funcion, and already was using -DTHREADSAFE=1. I still getting a few of "sqliteOsEnterMutex: Assertion `!inMutex' failed" and getting much more "library routine called out of sequence" about the sqlite_compile(), Im using simple cal

Re: [sqlite] Concurrence in DB - again

2004-03-07 Thread Thiago Mello
Hi Sqlite list, Tito and Arnaud, thanks for your help, I use the example of the link above, and I use the nanosleep() in every SQL exec function of my program that may be use by two process/thread. But Im still not geting it right, Im geting this msg and a "Abort" in my program: SQLITE_BUSY: sle

Re: [sqlite] Concurrence in DB

2004-02-24 Thread Tito Ciuro
Hello Thiago, http://www.sqlite.org/cvstrac/wiki?p=MultiThreading Regards, -- Tito On 24 feb 2004, at 10:31, Thiago Mello wrote: Hi, Im using Sqlite in my application, and I want to two process bem able to insert records in a table, SQLite support process concurrence, or I have to do this i

[sqlite] Concurrence in DB

2004-02-24 Thread Thiago Mello
Hi, Im using Sqlite in my application, and I want to two process bem able to insert records in a table, SQLite support process concurrence, or I have to do this in my program? If I have to do this in my program some one have a idea how can I do this I tried to use some things already. Thanks, -