is there a way to do SELECT SCOPE_IDENTITY() in ADODB?

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") = instrument
    .Update ' stores the new record        
End With

this is how i am adding records. is it possibel to do something lik ethis???:

With rs
    .AddNew ' create a new record
    ' add values to each field in the record
    .Fields("datapath") = dpath开发者_C百科
    .Fields("analysistime") = atime
    .Fields("reporttime") = rtime
    .Fields("lastcalib") = lcalib
    .Fields("analystname") = aname
    .Fields("reportname") = rname
    .Fields("batchstate") = bstate
    .Fields("instrument") = instrument
     SCOPE_IDENTITY()  <----------------
    .Update ' stores the new record


End With

No, there is not.

You should make an explicit INSERT statement followed by a call to SCOPE_IDENTITY in the same batch.

After you have executed the Update command, the identity will be placed in the corresponding field in the recordset. You can read it from there.

Example:

id = .Fields("id")