title: I have a query on auto increment on sqlite database
body: <p>I have the following database:</p>
  
  <pre><code>CREATE TABLE QUESTION (
      QUES_ID  INTEGER AUTO INCREMENT,
      TOPIC_ID INTEGER NOT NULL,
      QUESTION_DESC TEXT NOT NULL,
      CHOICE_A TEXT,
      CHOICE_B TEXT,
      CHOICE_C TEXT,
      CHOICE_D TEXT,
      PRIMARY KEY (QUES_ID,TOPIC_ID),
      FOREIGN KEY (TOPIC_ID) REFERENCES TOPIC(TOPIC_ID)
  );
  </code></pre>
  
  <p>When I insert info like that...</p>
  
  <pre><code>INSERT INTO 
      QUESTION (TOPIC_ID,QUESTION_DESC,CHOICE_A,CHOICE_B,CHOICE_C,CHOICE_D)
  VALUES 
      (1,'Blue or blue?','red?','yellow?','black?','yellow again?');
  </code></pre>
  
  <p>I get the following results, the <code>ques_id</code> doesn't get assigned!</p>
  
  <pre><code>QUES_ID     TOPIC_ID   QUESTION_DESC  CHOICE_A  CHOICE_B  CHOICE_C  CHOICE_D     
  ----------  ---------  -------------  --------- --------- --------- -------------
               1         Blue or blue?  red?      yellow?   black?    yellow again?
  </code></pre>