Returns or sets the status of the current row or column.
Syntax
object.Status [= value]
The Status property syntax has these parts:
| Part | Description |
| object | An object expression that evaluates to an object in the Applies To list. |
| value | A Long integer representing the type of cursor as described in Settings: |
Settings
The Status property has these settings:
| Constant | Value | Prepared Property Setting |
| rdRowUnmodified | 0 | (Default) The row or column has not been modified or has been updated successfully. |
| rdRowModified | 1 | The row or column has been modified and not updated in the database. |
| rdRowNew | 2 | The row or column has been inserted with the AddNew method, but not yet inserted into the database. |
| rdRowDeleted | 3 | The row or column has been deleted, but not yet deleted in the database. |
| rdRowDBDeleted | 4 | The row or column has been deleted locally and in the database. |
Remarks
The value of this property indicates if and how this row or column will be involved in the next optimistic batch update.
When you use the optimistic batch update cursor library and need to specify which rows are to be updated in the next batch operation, you set the rdoResultset object's Status property. For example, suppose you are working with an unbound Grid control filled with rows from a query. The user selects one of the rows and you detect that a change has been made in the row. At this point you can mark this row for updating by setting the Status property to rdRowModified. Similarly, if a row is added or deleted, you can use the appropriate Status property setting to so indicate. When you use the BatchUpdate method, RDO will submit an appropriate operation to the remote server for each row based on its Status property.
Once the BatchUpdate operation is complete, you can examine the Status property of each row to determine if the update is successful. If the Status value does not return rdRowUnmodified after the BatchUpdate, the operation to update the row could not be completed. In this case you should check the rdoErrors collection and the BatchCollisionRows property for rows.