title: Deploying SQLite database to Android with Delphi FireMonkey
body: <p>I am trying to deploy an application to run on the android emulator using delphi that uses an SQLite database and populates a combobox with the query results.</p>
  
  <p>I Have tested all the code on a Win32 application and everything is working as intended, however when i deploy the SQLite database and try to run the application on the emulator i raise an exception with "TDBXError with message" and the ErrorMessage contains 'no such table: cars'</p>
  
  <p>Below is the code for my form.</p>
  
  <pre><code>    var
    Form1: TForm1;
  
  implementation
  
  {$R *.fmx}
  
  procedure TForm1.Button1Click(Sender: TObject);
  begin
    // Populate Manufacturer box
    SQLConnection1.Connected := True;
    SQLQuery1.SQL.Clear;
    SQLQuery1.Close;
    SQLQuery1.SQL.Add('SELECT DISTINCT manufacturer FROM cars');
    try
      SQLQuery1.Open;
      cbManufac.Items.Clear;
      while not SQLQuery1.Eof do
      begin
        cbManufac.Items.Add(SQLQuery1.Fields[0].AsString);
        SQLQuery1.Next;
      end;
    finally
      SQLQuery1.Close;
    end;
  end;
  
  procedure TForm1.SQLConnection1BeforeConnect(Sender: TObject);
  begin
    {$IF DEFINED(iOS) or DEFINED(ANDROID)}
    SQLConnection1.Params.Values['ColumnMetadataSupported'] := 'False';
    SQLConnection1.Params.Values['Database'] :=
        System.IOUtils.TPath.Combine(TPath.GetDocumentsPath, 'cars.sqlite');
    {$ENDIF}
  end;
  
  end.
  </code></pre>
  
  <p>I Have made sure System.IOUtils is added to uses and my database file is added under my projects deployment settings. </p>
  
  <p>If i activate Win32 and test the application the combobox entries are added just fine.</p>
  
  <p>On the form designer i am using TSQLConnection and TSQLQuery</p>
  
  <p>Can anybody point me in the right direction. </p>
  
  <p>Thanks</p>