Siebel NextRecord And DeleteRecord In Loops Skips Record
DeleteRecord implicitly moves the record pointer to the next record in the record set. If a call to NextRecord is made after a call to DeleteRecord the record pointer will move twice. This means that a record will be skipped. When deleting records in loops every other record will be skipped.
Here is a visual analog.
Record one ß (DeleteRecord is called on this record.)
Record two
Record three
Record four
After the DeleteRecord is called the record pointer is on the second record.
Record twoß (Record pointer is now on record two)
Record three
Record four
Now NextRecord is called.
Record two
Record threeß (Record pointer is now on record three)
Record four
DeleteRecord is called again on record three.
Record two
Record fourß (Record pointer is now on record four)
So, record two has been skipped.
example by DW:
function DeleteContainerType(&arrType,quoteId) {. . . . ExecuteQuery(ForwardOnly); var record = FirstRecord(); while(record) { DeleteRecord(); record = FirstRecord(); } . . . .}
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步