ADO Prepared Property

The Prepared property sets or returns a Boolean value that, if set to True,indicates that the command should save a prepared version of the query specified in the CommandText propertybefore execution."

Syntax

objcommand.Prepared=true or false

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.ActiveConnection=conn
comm.CommandText="orders"
comm.Prepared=true
response.write(comm.Prepared)

conn.close
%>

❮ Complete Command Object Reference

Contact US

Email:

Content:

ASP Tutorials

WP Tutorial

ASP.NET Razor

ASP Classic

ASP Reference

ADO Tutorial

ADO Objects