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