The Immobile Rows property specifies whether to reorder inserted rows in a recordset.
object.Properties("Immobile Rows") [= value]
object
Expression that evaluates to an object in the Applies To list.
value
Boolean that specifies whether to reorder inserted rows, as specified in Settings.
| Value | Description |
|---|---|
| True | The recordset will not reorder inserted or updated rows. Rows appear at the end of the recordset. |
| False | If the recordset is ordered, inserted rows and updated rows (where one or more of the columns in the ordering criteria are updated) obey the ordering criteria of the recordset. If the recordset is not ordered, inserted rows are not guaranteed to appear in a determinate position and the position of updated rows is not changed. |
adBoolean
Read/write
DBPROP_IMMOBILEROWS
This property is meaningful only if the Own Inserts Visible property is set to True.