title: How to return the value of AUTO INCREMENT column in SQLite with VB6
body: <p>I have a table in SQLite:</p>
  
  <pre><code>CREATE TABLE "EventType" 
  (
  [EventTypeID] INTEGER PRIMARY KEY, 
  [EventTypeName] VARCHAR(50) NOT NULL UNIQUE
  );
  </code></pre>
  
  <p>Since EventTypeID is an integer and a primary key, that automatically makes it an auto-incrementing column, and that works fine.</p>
  
  <p>I'd like to insert a row into the table and get the newly incremented value from VB6.</p>
  
  <pre><code>Dim oRs as Recordset
  dim oCmd as new Command
  
  oCmd.ActiveConnection = GetConnection()
  oCmd.Source = "insert into EventType (EventTypeName) values ('blah')"
  oCmd.Execute
  </code></pre>
  
  <p>Is there an automatic way to retrieve the newly created EventTypeID without having to issue another query (select max(EventTypeID) from EventType))?</p>
  
  <p>I seem to remember from VB6 days long time ago, that there was a way to do that.</p>