title: what does select @@identity do?
body: <p>i am connecting to a mysql database through excel using odbc</p>
  
  <p>what does this line do?</p>
  
  <pre><code>Set rs = oConn.Execute("SELECT @@identity", , adCmdText)
  </code></pre>
  
  <p>i am having trouble updating the database:</p>
  
  <pre><code>   With rs
          .AddNew ' create a new record
          ' add values to each field in the record
          .Fields("datapath") = dpath
          .Fields("analysistime") = atime
          .Fields("reporttime") = rtime
          .Fields("lastcalib") = lcalib
          .Fields("analystname") = aname
          .Fields("reportname") = rname
          .Fields("batchstate") = "bstate"
          .Fields("instrument") = "NA"
          .Update ' stores the new record
      End With
  </code></pre>
  
  <p>it is ONLY updating .Fields("instrument") = "NA", but for all other fields it is putting NULL values</p>