Page 1 of 1

Sqlite with Delete db

Posted: Mon Jul 09, 2018 4:32 pm
by Dummy1912
Hello,

I was wondering if someone can help me out
i need a function to delete the DB after its been created and then delete it again
if the user cancel before finish it

but i use this code:
Code: Select all
File.delete(somefile)
but i got an error that says file is in us

Thank you

Dummy1912

Re: Sqlite with Delete db

Posted: Wed Jul 11, 2018 4:50 pm
by CodenStuff
I remember having this problem. I'm not sure how your program is working but could be due to sqlite using the file. You may need to exit sqlite before attempting to delete the file.

Other options are try garbade collection or put the delete function in a loop/timer until file is deleted as it can take a few seconds for a file to be deleted/moved which prevents you accessing it.

Re: Sqlite with Delete db

Posted: Thu Jul 12, 2018 3:02 pm
by Dummy1912
Hi,

Yes its true, sqlite still use the db file
i'll try to close it first and then we will see hows that going
and i come back ;)

Thanks for the idea :D