Oracle Objects for OLE Release 9.0.1 Part Number A90173-01 |
|
sql_statement
| Any valid Oracle SQL SELECT statement.
|
slicesize
| Cache slice size.
|
perblock
| Cache slices per block.
|
blocks
| Cache maximum number of blocks.
|
FetchLimit
| Fetch array size.
|
FetchSize
| Fetch array buffer size.
|
options
| A bit flag indicating the status of any optional states of the dynaset. You
can combine one or more options by adding their respective values. Specifying
&H0& gives the following defaults for the dynaset:
· Behave like Visual Basic Mode for a database: Field values not explicitly set are set to NULL, overriding server column defaults. · Perform automatic binding of database parameters. · Strip trailing blanks from character string data retrieved from the database. · Create an updatable dynaset. · Cache data on client. · Force a MoveFirst on dynaset creation. · Maintain read-consistency. |
SnapShotID [optional]
| A SnapshotID obtained from the SnapShot property of an OraDynaset.
|
Constant
| Value
| Description
|
ORADYN_DEFAULT
| &H0&
| Accept the default behavior.
|
ORADYN_NO_AUTOBIND
| &H1&
| Do not perform automatic binding of database parameters.
|
ORADYN_NO_BLANKSTRIP
| &H2&
| Do not strip trailing blanks from character string data retrieved from the
database.
|
ORADYN_READONLY
| &H4&
| Force dynaset to be read-only.
|
ORADYN_NOCACHE
| &H8&
| Do not create a local dynaset data cache. Without the local cache, previous
rows within a dynaset are unavailable; however, increased performance results
during retrieval of data from the database (move operations) and from the rows
(field operations). Use this option in applications that make single passes
through the rows of a dynaset for increased performance and decreased resource usage.
|
ORADYN_ORAMODE
| &H10&
| Same as Oracle Mode for a database except it affects only the dynaset being
created. If database was created in Oracle Mode, dynaset inherits the property
from it (for compatibility)
|
ORADYN_NO_REFETCH
| &H20&
| Behaves same as ORADB_NO_REFETCH mode for a database except this mode affects
only the dynaset being created. If the database was created in ORADB_NO_REFETCH
mode, the dynaset inherits the property for compatibility.
|
ORADYN_N_MOVEFIRST
| &H40&
| Does not force a MoveFirst on dynaset creation. BOF and EOF are both TRUE.
|
ORADYN_DIRTY_WRITE
| &H80&
| Update and Delete will not check for read consistency.
|
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|