Hi I am using window odbc connection to save my data from notes db to sql table, prevouisly the adding row into the sql table was fine, somehow when the data in the sql table hit the 12079 records, then I unable to add my data into the sql table any more… any can help please …
my sql table name is ‘tblBarCode’ , if I empty the records in the table then the updaterow function is working fine
here is my script
If con.ConnectTo(“SQLbarcode”, “ngm”, “odbcnotes”) Then
Set qry.Connection = con
qry.SQL = “SELECT * FROM tblBarCode”
Set res.Query = qry
Call res.Execute
If res.GetError <> DBstsSUCCESS Then
Messagebox res.GetExtendedErrorMessage, _
res.GetError & " " & res.GetErrorMessage
connectSQLRet = False
Exit Sub
End If
res.LastRow
res.AddRow
Call res.SetValue(“FilingID”, “1119”)
Call res.SetValue(“Barcode”, “B0099”)
Call res.SetValue(“Engagement Name”, “nyan”)
Call res.SetValue(“FileType”, “”)
Call res.SetValue(“FileLoc”, “”)
Call res.SetValue(“LoS”, “”)
Call res.SetValue(“Office”, “”)
Call res.SetValue(“Ind”, “”)
Call res.SetValue(“SeqNo”, “”)
res.UpdateRow
Call con.Disconnect
End If
Msgbox “Update Finish”