6. Working with Arrays, Table Fields, and Collections : Arrays : How You Can Manipulate Arrays : How You Can Delete Rows in an Array
 
Share this page                  
How You Can Delete Rows in an Array
When you want to delete rows from an array and do not need to keep track of the deleted rows, use either of the following methods:
The RemoveRow method to delete rows one row at a time
The syntax for the RemoveRow method is:
integer = ArrayObject.RemoveRow(rownumber = integer)
You must include the rownumber parameter to identify the row to be deleted.
If the row is deleted successfully, the method returns ER_OK. If the row is not found, the method returns ER_ROWNOTFOUND.
After the specified row is deleted, OpenROAD adjusts the numbers of the rows that followed the deleted row. For example, if you remove row number 5, then the current row 6 becomes the new row number 5.
The Clear method to delete all the rows at once
The syntax for the Clear method is:
integer = ArrayObject.Clear()
Both of these methods actually delete rows from the array (and any associated table field display), rather than just marking the rows deleted. Rows that have a _RowState value of RS_DELETED and those with positive sequence numbers are deleted.