Oracle Objects for OLE
Part Number A90173-01
||The Oracle Network specifier used when connecting the data control to a
||The username and password to be used when connecting to an Oracle database.
||A bit flag word used to set the optional modes of the database. If options = 0, the default mode settings will apply. The table below shows the
different modes you can use, which can be combined by adding their respective values:
||Visual Basic Mode (Default)
Field (column) values not explicitly set are set to NULL when using AddNew or Edit. The NULL values override any server column defaults.
Wait on row locks when using Edit ("SELECT... FOR UPDATE").
Non-blocking SQL functionality will not be enabled.
Let Oracle database set the default field (column) values when using AddNew. The Oracle default column values are fetched again from database immediately after the insert or add operation.
Note: If you use triggers, you should fetch the data again using the full Oracle Mode.
||Lock No-Wait Mode
Do not wait on row locks. When you use Edit to update a row that is locked by another user or process, Lock No Wait mode results in an immediate return of an error code.
Note: This option only applies to OraDynaset. It has no effect on OraSqlStmt objects or ExecuteSQL calls. It only raises an error in the case of a locked row.
||Oracle Mode (No Refetch)
Like Oracle Mode, but data is not refetched to the local cache, boosting performance.
Caution: Use the No Refetch mode only when you intend to insert rows without editing them, because server column defaults will cause inconsistencies between server data and the local cache. Attempting to edit after inserting in this mode will cause a "Data has been modified" (4119) error.
This mode turns on Non-Blocking mode on SQL statement execution. Non-Blocking mode affects the SQL statements processed using the ExecuteSQL, CreateDynaset or CreateSQL methods.
Note: This parameter only applies to Windows 3.1 where it is used solely to prevent hanging during cooperative multi-tasking. It has no effect in Windows 95 or NT, in which cases the parameter is ignored. You cannot use this parameter to implement non-blocking with polling or other asynchronous callbacks.
||Enlist in MTS Mode
This mode determines whether the OraDatabase object enlists in the Microsoft Transaction Server (MTS) mode.
||Enlist For Callbacks Mode
This mode turns on the event notification. This mode has to be enabled to receive Failover Notifications.