title: titanium uncaught error: no such table
body: <p>I'm using titanium and testing against an android emulator - but any advice relevant to iOs is also welcome!</p>
  
  <p>i am trying to use titanium with a database. I'm using the firefox sql lite plugin to make my db - so i make it, and then i go </p>
  
  <pre><code>database &gt; export database &gt; to a location in my titanium app project that is under "Resources" folder
  </code></pre>
  
  <p>ok, neat.</p>
  
  <p>Then i have this code:</p>
  
  <pre><code>var db = Ti.Database.install('/db/wibbler.sql','wibbler');
  
  function getLanguages(){
  var sql = 'select * from language order by name desc';
  
  var results = [];
  
  var resultSet = db.execute(sql);
  
  while (resultSet.isValidRow()){
      results.push({
          name: resultSet.fieldByName('name'),
          id: resultSet.fieldByName('id'),
          desctiption: resultSet.fieldByName('description')
      });
      reultSet.next();
  }
  resultSet.close();
  return results;
  }
  </code></pre>
  
  <p>As you can see, the location of the file is </p>
  
  <pre><code>Resources/db
  </code></pre>
  
  <p>and the db file is called "wibbler.sql"</p>
  
  <p>The problem is, when i run my app, it complains that the sql i'm using refers to a table that doesn't exist - to wit:</p>
  
  <p>uncaught error: no such table</p>
  
  <p>What is the deal?</p>