ReadOnly Property

Applies To

Oracle Data Control


Determines whether the dynaset will be used for read-only operations. Read/write at design time and run time.


oradata1.ReadOnly = [ True | False ]

Data Type

Integer (Boolean)


By default, ReadOnly is False which means that an attempt will be made to create an updatable dynaset by selecting ROWIDs from the database. If ReadOnly is set to True, a non-updatable dynaset is created (ROWIDs are not selected from the database and cached) and operations will be somewhat faster.

If the SELECT statement contains a LONG or LONG RAW column, ROWIDs are needed whether the dynaset will be updatable or not.

Changing this property does not take effect until a Refresh method is sent to the data control.