title: No such table SQLITE_SEQUENCE from AIR/Actionscript
body: <p>I'm trying to reset the seed for an autoincrement field in SQLITE using AIR/ActionScript/Flex 4.5.</p>
  
  <p>I'm doing what should normally work:</p>
  
  <pre><code>DELETE FROM SQLITE_SEQUENCE WHERE NAME = 'myTable'
  </code></pre>
  
  <p>I've checked that the database actually contains a SQLITE_SEQUENCE table. I'm able to execute the above statement without errors directly via the Firefox SQLITE plugin (SQLite Manager).</p>
  
  <p>However, when I try to do the same using actionscript, I get an error:</p>
  
  <blockquote>
    <p>No such table 'SQLITE_SEQUENCE'.</p>
  </blockquote>
  
  <p>All I could find in searching around was this one guy who posted everywhere he could find - only to be left without an answer: 
  <a href="http://www.google.com.au/url?sa=t&amp;source=web&amp;cd=1&amp;ved=0CBgQFjAA&amp;url=http://old.nabble.com/Unable-to-call-SQLITE_SEQUENCE-from-adbe-air-td23546850.html&amp;ei=1alYToj9HaXhiALql5WmCQ&amp;usg=AFQjCNG1fXEBfNNUwkXUMAHsxMaScVWB8w" rel="noreferrer">here</a>
   and 
  <a href="http://www.google.com.au/url?sa=t&amp;source=web&amp;cd=2&amp;ved=0CB4QFjAB&amp;url=http://osdir.com/ml/sqlite-users/2009-05/msg00343.html&amp;ei=1alYToj9HaXhiALql5WmCQ&amp;usg=AFQjCNGzfmD7fSeWCMXlfMiP08NcBQsxBw" rel="noreferrer">here</a>
   and 
  <a href="http://www.google.com.au/url?sa=t&amp;source=web&amp;cd=7&amp;ved=0CEMQFjAG&amp;url=http://forums.adobe.com/thread/429439&amp;ei=1alYToj9HaXhiALql5WmCQ&amp;usg=AFQjCNECBmuEing6Lj7JTUi0-G3NimWXJw" rel="noreferrer">here</a></p>
  
  <p>Any ideas?</p>