Ugh, I forgot that I wrote this thread. Amy, thx for the reply. Sorry, I have been busy with other projects. I really appreciate your reply.
>From what I remember, this is having to do with different tables. If you do insertion to table A, B, C, etc simultaneously, your app will hung-up. I made a queue system to handle multiple insertion op. It works great! --- In flexcoders@yahoogroups.com, "Amy" <amyblankens...@...> wrote: > > --- In flexcoders@yahoogroups.com, "handitan" <handitan@> wrote: > > > > Alright fellas, > > > > Spill out the secret. > > When I do the multiple-insertion simultaneously, those operations just > > stopped and any new transaction-transaction op request is ignored. > > > > My idea so far is to put any new transaction-request in a queue if a > > transaction is currently in the process, and then after that transaction is > > finished then do the next transaction-request from the queue. > > Doesn't SQLLite have any syntax like > > INSERT INTO MyTable (Field1, Field2) > VALUES (Obj1Field1, Obj1Field2), > (Obj2Field1, Obj2Field2), > (Obj3Field1, Obj3Field2) > > ? > > This would actually make the multiple inserts simultaneously, rather than > trying to multiple sql statements all intependently trying to be simultaneous. > > -Amy >