when initially installed my app copies the database to default external dir. How do I automatically do this when my app is updated? it doesn't copy the database as its already there. it doesn't realise its an older version.
You will have to have as part of your installation a file containing the "database version" or, you could check for a specific number of database fields, there are many ways to do it, but it won't happen automatically, you will have to write code to do it.