[flexcoders] Any working example on SQlite transaction in Async mode

[George]

Hi there,

I check lots of documents and google examples on SQLite transaction, 
most of them in sync mode that not fit what we need exactly.

What I need is during the transaction, I want to insert a list of items 
into a table. I reuse a single insert statement prepared. So what I did:

connection.begin(SQLTransactionLockType.IMMEDIATE);
for(var i:int=0; i<items.length; i++)
{
      // execute an insert statement instance with item parameters
      ...
}
connection.commit();

The problem I found, in async mode, after the statement instance is 
executed, it didn't finish its own task, so its status is 'executing', 
that means next item is not possible to be continue.

I guess in this case I cannot use transaction?

Thanks,
George