title: Delphi TFDTable SqLite problems
body: <p>I deployed a <code>sample.s3db</code> SqLite to my Delphi android project.</p>
  <ol>
  <li><p>set folder to:</p>
  <p><code>fdconnection1.params.Database := system.ioutils.TPath.Combine( system.ioutils.TPath.GetDocumentsPath, 'sample.s3db');</code></p>
  </li>
  </ol>
  <p>in FDConnection1BeforeConnect event.</p>
  <ol start="2">
  <li>in Project-Deployment, set folder to <code>assets\internal\ for Android</code></li>
  </ol>
  <p>However, when I run the app, apparently it can find the physical file, but it says my <code>tablename</code> &quot;Customers&quot; is not found.</p>
  <p>so in the <code>BeforeConnect</code> code, if I add a CREATE TABLE SQL create code if not exists, then everything works well but of course the table is empty (whereas my deployed sample.s3db is not empty) ... which proves the FILE sample.s3db was found and not corrupted, but somehow the Table was not found.</p>
  <p>Even tried to change in <code>BeforeConnect</code></p>
  <pre><code>  FDConnection1.Params.Values['OpenMode'] := 'ReadWrite';
  </code></pre>
  <p>but it still doesn't work.</p>
  <p>Any ideas the table name does not work?</p>
  <p>I tried to change table name to all caps, in case Android is case-sensitive but it also does not work.</p>