Jump to content
toufik

The location of sqllite database ?

Recommended Posts

good morning every one ^^ how is every one doing ))
1- i have fmx android app that s create sqllite db on create ,what's  the location of db on the phone and is it const location ? (does not change for every other phones)
2- what's the proper way to copy it from that location to sd card (backup) ?
thanks and take care ☺️

Share this post


Link to post

For iOS: StartUp\Documents\

For Android: .\assets\internal

Use those folders if you deploy an existing DB. This is the Project Options section.

 

At runtime you can use something like this

{$IF DEFINED(iOS) or DEFINED(ANDROID)}
  FDConnection.Params.Values['ColumnMetadataSupported'] := 'False' ;
  FDConnection.Params.Values['Database'] := TPath.Combine(TPath.GetDocumentsPath, 'mydb.sqlite') ;
{$ENDIF}

Then do whatever you need to create/open/update, etc...

 

  • Like 1

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×