Updating Sql Lite

[Cancerinform]

Hi,

I created an air application with Flash builder with a SQL Lite database. When I delete a row from one table, the problem is that the deletion is not updated. Only when I close and open the application the deletion is effective. How can I instantly update the database so that the change becomes effective immediately?

[Guest]

Not sure if this will help you but I generally use Atomic Commit.

http://www.sqlite.org/atomiccommit.html

Good Luck to you.

Bob

[Cancerinform]

Thanks. I am not sure that will solve my problem. As  I said the Database information has been changed, but  the old information still seems to be in cache. It is also strange, because when I add a row it updates  ok.

Apart from that do you have a simple code example for the AC?