{ Learn Code. Share Code. Teach Code. Love Code. }

  • Sqlite with Delete db

  • Do you need something made? then ask in here.
Do you need something made? then ask in here.
Forum rules: Please LOCK your topics once you have found the solution to your question so we know you no longer require help with your query.
 #84403  by Dummy1912
 Mon Jul 09, 2018 4:32 pm
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
 #84404  by CodenStuff
 Wed Jul 11, 2018 4:50 pm
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.
 #84405  by Dummy1912
 Thu Jul 12, 2018 3:02 pm
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