Replace DB

[luke2012]

Hi to all,
there is a way to replace a db file copied with this function with a updated db file ?

TargetDir = DBUtils.CopyDBFromAssets("my.db")
SQLEngine.Initialize(TargetDir, "my.db" , False)

 

[barx]

the 'false' at the end means that if the file already exists it won't be overwritten. Set this this to true and it will. Bear in mind though that this will overwrite the file and not merge it so any data in existing will be lost. I.e. any records added since install.

 

[Erel]

Actually the last parameter is CreateIfNecessary. If you set it to false and the database file doesn't exist you will get an error. It never overwrites an existing database.

You can modify CopyDBFromAssets sub and change its behavior to copy the file even if the target file exists.

 

[luke2012]

Thanks for the support!

 

[barx]

Bugger. I really must stop giving out bad info. Sorry.

I'd modified dbutils on my system to add another parameter for overwriting db so I could overwrite when id made modification.

Note to self: check info is correct before posting. Lol

Sent from my HTC Vision using Tapatalk