Skip Headers
Oracle® Objects for OLE Developer's Guide
11g Release 2 (11.2) for Microsoft Windows

Part Number E17727-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

Options Property

Applies To

Oracle Data Control


Determines one or more characteristics of the database and all dynasets associated with the data control. Read/write at design time and run time.


oradata1.Options = database_optionsdatabase_options = oradata1.Options

Data Type

Long Integer


This property is a bit flag word used to set the optional modes of the database. If options = 0, the default settings will apply. The following modes are available:

Options Property Flag Values

The Options property flag values are:

Constant Value Description
ORADB_DEFAULT &H0& Accepts the default behavior.
ORADB_ORAMODE &H1& Lets Oracle Database set default field (column) values.
ORADB_NOWAIT &H2& Does not wait on row locks when executing a SQL "SELECT ... FOR UPDATE" statement.

These values can be found in the oraconst.txt file. Options may be combined by adding their respective values.

This property is the same as the options passed to the OpenDatabase method. Just as with OpenDatabase, these options affect the OraDatabase object and all associated dynasets created from that database.

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