title: SQLite Error: near "s": syntax error
body: <p>me always get this error </p>
  
  <blockquote>
    <p>near "s": syntax error</p>
  </blockquote>
  
  <p>my implementation:</p>
  
  <pre><code>litecon.ConnectionString = "Data Source=" + AppAddress + "\\database\\mynew22.db;Version=3;UTF16Encoding=True";
  </code></pre>
  
  <p>error recived form this method -> liteda.Fill(dt);</p>
  
  <pre><code>        if (lang == "FaToMe")
              liteda.SelectCommand = new SQLiteCommand("select * from mey where trans like '%" + str + "%'", litecon);
          else
              liteda.SelectCommand = new SQLiteCommand("select * from mey where pe like '%" + str + "%'", litecon);
  
          DataTable dt = new DataTable();
          liteda.Fill(dt); //liteda is SQLiteDataAdapter
  </code></pre>
  
  <p>no difference between this select commands...</p>
  
  <pre><code>"select * from mey where pe like '%" + str + "%'"
  </code></pre>
  
  <p>or</p>
  
  <pre><code>"select eng "
  </code></pre>
  
  <p>always say   near "s": syntax error</p>
  
  <h2>but if using "xselect * from mey", say near "x": syntax error</h2>
  
  <p>i'm using this library
  <a href="http://adodotnetsqlite.sourceforge.net/" rel="nofollow">http://adodotnetsqlite.sourceforge.net/</a></p>