title: SQLITE basic syntax
body: <p>I seem to misunderstand a basic syntax, why this sample works:</p>
  
  <pre><code>sqlite3_prepare_v2(db, "insert into test values('boo','boo',0);", strlen(querystring)+1 , &amp;stmt, NULL);
  
  if ((rc = sqlite3_step(stmt)) != SQLITE_DONE)
    fprintf(stderr, "Error: sqlite3_step() %d. Error Message %s;\n",rc,sqlite3_errmsg(db));
  </code></pre>
  
  <p>But when I try this query:
  "insert into test(strtest) values('boo');"</p>
  
  <p>I get an error:
  Error: sqlite3_step() 19. Error Message constraint failed;</p>
  
  <p>What am I missing?</p>
  
  <p>table test is: "create table test (blobtest BLOB(4) NOT NULL, strtest VARCHAR NOT NULL,  inttest INTEGER NOT NULL );"</p>
  
  <p>Thanks,
  Doori Bar</p>