J.2. Recordset.Open Method Options
There are 30 Win32 Registry functions that you can use from VBA. This section describes only 25 of them, because the remaining five require specialist knowledge of Windows security, which is well beyond the scope of this book.
J.2.1. CursorType Argument Options (CursorTypeEnum Values)
| Constant | Value | Description |
|---|---|---|
| AdOpenUnspecified | −1 | Hidden. No cursor type is specified. |
| AdOpenForwardOnly | 0 | Default. Specifies a forward-only cursor. This is similar to a static cursor, except that you can only scroll forward through the records. |
| AdOpenKeyset | 1 | Specifies a keyset cursor. This is similar to a dynamic cursor, except that records added by other users are not reflected in your recordset; however, records that other users delete are inaccessible in your recordset. |
| AdOpenDynamic | 2 | Specifies a dynamic cursor. In this cursor type, all additions, deletions, and modifications made by other users are visible in your recordset, and all types of row movement are allowed. If the provider supports bookmarks, they too are allowed. |
| AdOpenStatic | 3 | Specifies a static cursor. This cursor type is read-only, and additions, deletions, and modifications made by other users are invisible in your recordset. |
J.2.2. LockType Argument Options (LockTypeEnum Values)
| Constant | Value | Description |
|---|---|---|
| AdLockUnspecified | −1 | Hidden. A lock type is not specified. Clones are created with the same lock type as their original. |
| AdLockReadOnly | 1 | Specifies a read-only recordset. |
| AdLockPessimistic | 2 | Specifies pessimistic locking at record-level. |
| AdLockOptimistic | 3 | Specifies pessimistic locking at record-level. The record is locked only when you call the Update method. |
| adLockBatchOptimistic | 4 | Specifies optimistic locking for batch updated. |
J.2.3. Options Argument (Constant Values)
The Options argument can be one or more of the following constant values.
| Constant | Value | Description |
|---|---|---|
| CommandTypeEnum values | ||
| adCmdUnspecified | −1 | Hidden. No command type is specified. |
| AdCmdText | 1 | The Source argument is a command or the name of a stored procedure. |
| AdCmdTable | 2 | The Source argument is the name of a table. |
| AdCmdStoredProc | 4 | The Source argument is the name of a stored procedure. |
| AdCmdUnknown | 8 | Default. The type of command in the Source argument is unknown. |
| AdCmdFile | 256 | The Source argument is the name of a stored Recordset. |
| adCmdTableDirect | 512 | The Source argument is the name of a table. This option cannot be combined with adAsyncExecute. |
| ExecuteOptionEnum values | ||
| adOptionUnspecified | −1 | Hidden. The command is not specified. |
| AdAsyncExecute | 16 | The command executes asynchronously. This option cannot be combined with adCmdTableDirect. |
| AdAsyncFetch | 32 | The rows that remain to be retrieved after those specified by the CacheSize property are to be retrieved asynchronously. |
| adAsyncFetchNonBlocking | 64 | The main thread never blocks while retrieving data, so if the requested row has not been retrieved, the current row automatically moves to the end of the file. |
| This setting is ignored if the adCmdTableDirect option is used, or if you open a recordset from a stream that contains a persistently stored recordset. | ||
| adExecuteNoRecords | 128 | The Source argument is a command or stored procedure that does not return records. |
| AdExecuteRecord | 2048 | Hidden. The Source argument is a command or stored procedure that returns a single row as a Record object. |
Note: For information about how to view hidden objects in the Object Browser, refer to Chapter 2.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.