BatchCollisionCount Property

       

Returns a value that specifies the number of rows that did not complete the last batch-mode update.

Syntax

object.BatchCollisionCount

The object placeholder represents an object expression that evaluates to an object in the Applies To list.

Return Values

The BatchCollisionCount property return value is a Long expression that specifies the number of failing rows or 0 if all rows were processed.

Remarks

This property indicates how many rows encountered collisions or otherwise failed to update during the last batch update attempt. The value of this property corresponds to the number of bookmarks in the BatchCollisionRows array.

By setting the working rdoResultset object's Bookmark property to bookmark values in the BatchCollisionRows array, you can position to each row that failed to complete the most recent BatchUpdate operation.

After the collision rows are corrected, the BatchUpdate method can be called again. At this point RDO attempts another batch update, and the BatchCollisionRows property again reflects the set of rows that failed the second attempt. Any rows that succeeded in the previous attempt are not sent in the current attempt, as they now have a Status of rdRowUnmodified. This process can continue as long as collisions occur, or until you abandon the updates and close the result set.