Copy a SQLite file ... open, close or don't care

[Hubert Brandel]

Hi,

I want to copy an internal data.db onto the SD card, but do I have to close it first ?

Dim SQL1 As SQL
SQL1.Initialize(File.DirInternal, "data.db", True)
...
If File.Exists(File.DirInternal, "data.db") Then 
   ' SQL1.close
   File.Copy(File.DirInternal, "data.db", sCSVdirSD, "DatenSicherung.db")
   ' SQL1.Initialize(File.DirInternal, "data.db", True)      
End If

In Win32 I can't copy an open file, but Windows Mobile 6.5 don't care because of no other thread could use it.

What do you think ?

 

[Erel]

I recommend you to close the SQL object before copying the file. It will probably work properly without closing, however there is a chance that there is still some cached data that was not written.

 

[merlin2049er]

oh, do you need to close a sqlite db file before attaching it to an email?

Thanks,
Joe

 

[Erel]

If SQL is not closed then the file might not be fully written. Though you should still be able to attach it to an email.

 

[merlin2049er]

Thanks!