I have table with these Field
ID = AutoNumber < Primary
Software = Text
Version = Text
....
and i'm using these code to INSERT New Record
Have any way to known field ID of new Record have just added?
Hm ..I can use SELECT to Find it . But.. i hopy have another fast way to do..
Thanx
ID = AutoNumber < Primary
Software = Text
Version = Text
....
and i'm using these code to INSERT New Record
VB.NET:
strSQL = "SELECT * FROM SoftwareDetail"
Try
With rsSoftwareDetail
.Open(strSQL, conn, CursorTypeEnum.adOpenStatic, LockTypeEnum.adLockBatchOptimistic)
.AddNew()
.Fields("Software").Value = in_strSoftware
.Fields("Version").Value = in_strVersion
.Fields("Release").Value = CStr(in_dtRelease)
.Fields("ProLanguage").Value = in_strLanguage
.Fields("Packer").Value = in_strPacker
.Fields("Introduce").Value = in_strIntroduce
.Fields("FileSize").Value = in_lngFileSize
.Fields("HomePage").Value = in_strHomePage
.Fields("Download").Value = in_strDownload
.Update()
.UpdateBatch()
Have any way to known field ID of new Record have just added?
Hm ..I can use SELECT to Find it . But.. i hopy have another fast way to do..
Thanx