Does anyone know how to use sqlite transaction in AIR?
I tried the following codes but received an error saying that sql.execute() cannot be called because the executing is still true.
This happen for the second insert, the first 1 is ok.
sql.sqlConnection = _conn;
sql.text = statement;
if(parameters != null)
for(var i:int = 0; i < parameters.length; i++)
for(var j:int = 0; j < parameters[i].length; j++)
sql.parameters[parameters[i][j].name] = parameters[i][j].value;
Sounds like you're running an asynchronous operation inside a for-loop. You'd need to remove the for-loop, and setup something wait for a completion event to run the second execute().