ADO CommandText Ating Propyedate

Definition and Usage

Ang CommandText attribute ay maaaring itakda o ibalik ang isang string, na naglalaman ng isang provider command, tulad ng isang SQL statement, isang pangalan ng table, isang relative URL, o isang pagtawag sa stored procedure. Ang default value ay zero "" (zero-length string).

Syntax

objcommand.CommandText

Example

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set comm=Server.CreateObject("ADODB.Command")
comm.CommandText="orders"
response.write(comm.CommandText)
conn.close
%>