Hi,I have an agent which updates a record in the SQL server, using the set value method of ODBCResultset.
I have around 50 columns whose values needs to be updaeted.
The current logic using this method.
Wont there be much impact on the execution time of setting values? or Can i use one update query to update all the values at one shot.?
Please suggest me which is more effective and which take less amount of time to execute.
For eg:RetCode% = Res.SetValue(“HrsCo1”, MakeNonNullNumLong(appdoc.numNetFee0(0)))
RetCode% = Res.SetValue("HrsCu1" , MakeNonNullNumLong(appdoc.numNetFee1(0)))
RetCode% = Res.SetValue("HrsPr1", MakeNonNullNumLong(appdoc.numNetFee2(0)))
RetCode% = Res.SetValue("HrsPr2", MakeNonNullNumLong(appdoc.numNetFee3(0)))
RetCode% = Res.SetValue("FutureFees", 0)
RetCode% = Res.SetValue("StructEngPct", MakeNonNullPctLong(appdoc.numStructIns(0)) ) 'Percentage value
RetCode% = Res.SetValue("EnvironSvcsPct", 0)
RetCode% = Res.SetValue("OthProSvcsPct", MakeNonNullPctLong(appdoc.numOtherProfIns(0)) ) 'Percentage value
RetCode% = Res.SetValue("SeventyPerRule", "Yes")
RetCode% = Res.SetValue("LastYr70", MakeNonNullNumLong(appdoc.LastYr70(0)))
RetCode% = Res.SetValue("Prior2yrs70", MakeNonNullNumLong(appdoc.Prior2yrs70(0)))
RetCode% = Res.SetValue("Prior3yrs70", MakeNonNullNumLong(appdoc.Prior3yrs70(0)))
RetCode% = Res.SetValue("BusinessKind", "Direct")
RetCode% = Res.SetValue("NotesID", AppID)
RetCode% = Res.SetValue("PolicyNum", doc.PolicyNum(0))
RetCode% = Res.SetValue( "LastAccessed", Format(Now, "mm/dd/yyyy hh:mm:ss"))
RetCode% = Res.UpdateRow