ADO and SQL Server
Immobile Rows Property
The Immobile Rows property specifies whether to reorder inserted rows in a recordset.
Applies To
| Command Object | Recordset Object |
Syntax
object.Properties("Immobile Rows") [= value]
Parts
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.
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. |
Data Type
adBoolean
Modifiable
Read/write
OLE DB Property
DBPROP_IMMOBILEROWS
Remarks
This property is meaningful only if the Own Inserts Visible property is set to True.