ADO common statement explains, commonly used, but often forget [April 18, 2004 12:40]

zhaozj2021-02-16  79

[转] http://www.micsoft.net/tec_document.asp?tec_document_id=40

HRESULT Connection15 :: Open (_bstr_t userid, _bstr_t userid, _bstr_t password, long option) ConnectionsTRING is a connection string, userid is a username, Password is the login password, Options is the connection option, which is used to specify the Connection object to update the data. Options can be as follows: AdmodeunkNown: Default. The current license is not adModeRead settings: read-only adModeWrite: write only adModeReadWrite: can read and write adModeShareDenyRead: Connection object to prevent other read permissions to open a connection adModeShareDenyWrite: Connection object to prevent other write permissions to open a connection adModeShareExclusive: Connection object to prevent other open connection adModeShareDenyNone : Allow other programs or objects to establish connections in any permission

The prototype of the Execute method is as follows: _RecordSetPtr Connection15 :: Execute (_BSTR_T CommandText, Variant * Recordsaffected, long option) where CommandText is a command string, usually the SQL command. Parameter recordsaffected is the number of rows affected after the operation is completed. The parameter Options represents the type of content in CommandText. Options can take one of the values: AdcmdText: Indications CommandText is a text command adcmdtable: indicate that CommandText is a table name AdcmdProc: indicating that CommandText is a table name AdcmdProc: Store procedure adcmdunknown: unknown

转载请注明原文地址:https://www.9cbs.com/read-17208.html

New Post(0)