Try to explain what you are doing. How do you access SQLITE? What
language? What SQL are you using. How many concurrent users do you
have? Are you getting a LOCK error because of multiple users?
Cesar David Rodas Maldonado wrote:
please i need some help
On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
i insert numbers and select numbers, so what could be the solutions,
couse i have to do that
On 4/3/06, Pam Greene < [EMAIL PROTECTED]> wrote:
An INSERT can change the results of your SELECT, so the database has to
be
locked during INSERT. Otherwise, the result of your SELECT would depend
on
whether the INSERT had finished yet. (The INSERT might even have only
partly finished, which would mean the SELECT was looking at a database
in an
inconsistent state.) It's not good to have unpredictable results like
that.
For more explanation of why what you want isn't a good idea, see any
discussion of an "ACID" database, for example
http://en.wikipedia.org/wiki/ACID .
- Pam
On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
HElp me, couse i just need to do insert and select, i dont use delete
or
replate or update
On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
thanx man
but is posible open several DATABASE with a programm and do
transaccion
without locked the table???
On 4/3/06, Jay Sprenkle < [EMAIL PROTECTED]> wrote:
On 4/3/06, Cesar David Rodas Maldonado < [EMAIL PROTECTED]> wrote:
I have a database.... ok... i do a lot of insert and select, but
there
is
sometime that i cant do the select couse the database is
locked...
i have to do a lot of insert every time, so how can i do for
dont
lock
the
database...
understand guy?
Try this:
http://sqlite.org/lang_transaction.html