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();
}
. . . .}
复制代码

 

posted @   Flamo  阅读(651)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示