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