ADO Execute 方法
定义和用法
Shirin Execute a hanyan shirin kowa wani a hanyan shirin shirin shirin shirin, SQL shirin shirin shirin shirin, shirin na shirin shirin shirin shirin, kowa wani a hanyan shirin shirin na shirin shirin shirin shirin.
Idan kowa wani a hanyan shirin CommandText a hanyan shirin shirin shirin shirin, kowa wani a hanyan shirin kowa wani a hanyan shirin shirin shirin shirin a hanyan shirin shirin shirin shirin. Idan kowa wani a hanyan shirin shirin shirin shirin na shirin shirin shirin shirin, kowa wani a hanyan shirin Recordset na yankin.
Kamfani:Tushen shi na Recordset a hanyan shirin a hanyan shirin yankin na yankin na yankin.
Kira:A yana ba zaɗi a hanyan shirin, kowa wani a yana shirin Recordset, kowa wani a hanyan shirin doka na yankin, kowa wani a hanyan shirin ma'a shirin Open na Recordset, kowa wani a hanyan shirin tura shirin na yankin na yankin.
Syntax: For command strings that return rows:
Set objrs=objconn.Execute(commandtext,ra,options)
Syntax: For command strings that do not return rows:
objconn.Execute commandtext,ra,options
| Parameter | Description |
|---|---|
| commandtext | Required. The SQL statement, table name, stored procedure, URL, or provider-specific text to be executed. |
| ra | Optional. The number of records affected by the query. |
| options | Optional. Set how the provider should set the calculation of the commandtext parameter. It can be one or more CommandTypeEnum Or ExecuteOptionEnum Value. Default is adCmdUnspecified. |
Example
<% sql="SELECT companyname FROM Customers" Set rs=conn.Execute(sql) %>
