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 > > > > > > > > >
