I am facing a problem with async connection to SQLite in AIR. I have a search application, which by default searches 100 results from some thousands of data, on load.
So initially it takes some time to execute and provide the result.
Meantime if I do a new search, it waits till the first execution is completed and then starts executing the new one, so its a long time to get the final result. Is there any way to stop the current execution.
I tried SQLStatement.cancel() and also SQLConnection.cancel() but did not work as expected. Any help will be appreciated.