最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
ADO enumeration constants
时间:2008-01-19 编辑:简简单单 来源:一聚教程网
Each of this enum constants are defined in ADO.
Click each enum below to show its constants, values and description.
Connection object
ConnectOptionEnum
Constant Value Description
adAsyncConnect 16 Opens the connection asynchronously. The ConnectComplete event may be used to determine when the connection is available.
adConnectUnspecified -1 Default. Opens the connection synchronously.
Specifies whether the Open method of a Connection object should return after (synchronously) or before (asynchronously) the connection is established.
connection.Open ConnectionString, UserID, Password, Options
ConnectPromptEnum
Constant Value Description
adPromptAlways 1 Prompts always.
adPromptComplete 2 Prompts if more information is required.
adPromptCompleteRequired 3 Prompts if more information is required but optional parameters are not allowed.
adPromptNever 4 Never prompts.
Specifies whether a dialog box should be displayed to prompt for missing parameters when opening a connection to a data source.
connection.Properties("Prompt") = adPromptNever
Recordset object
CursorLocationEnum
Constant Value Description
adUseClient 3 Uses client-side cursors supplied by a local cursor library. Local cursor services often will allow many features that driver-supplied cursors may not, so using this setting may provide an advantage with respect to features that will be enabled. For backward compatibility, the synonym adUseClientBatch is also supported.
adUseNone 1 Does not use cursor services. (This constant is obsolete and appears solely for the sake of backward compatibility.)
adUseServer 2 Default. Uses data-provider or driver-supplied cursors. These cursors are sometimes very flexible and allow for additional sensitivity to changes others make to the data source. However, some features of the Microsoft Cursor Service for OLE DB (such as disassociated Recordset objects) cannot be simulated with server-side cursors and these features will be unavailable with this setting.
-
上一个: 自动获取表格数据添加,修改数据库数据的类
-
下一个: 常用数据库操作的自定义函数
相关文章
- VBS 批量Ping的项目讲解 09-19
- 如何封装一个Ajax函数介绍 09-16
- ASP实现加法验证码方法 09-16
- ASP错误捕获的几种常规处理方法介绍 09-16
- ajax实现城市三级联动的代码介绍 09-16
- asp中获取日期为星期几的技巧 09-14