Object ng Command sa ADO

Command object

The ADO Command object is used to execute a simple database-oriented query. This query can perform actions such as creating, adding, retrieving, deleting, or updating records.

If this query is used to retrieve data, this data will be returned as a RecordSet object. This means that the retrieved data can be manipulated by the properties, collections, methods, or events of the RecordSet object.

The main feature of the Command object is its ability to use stored queries and parameterized stored procedures.

ProgID

set objCommand=Server.CreateObject("ADODB.command")

Property

Property Paglalarawan
ActiveConnection Set or return a string that contains the definition of the connection or Connection object.
CommandText Set or return a string value that contains the provider command (such as SOL statement, table name, or stored procedure call). The default value is "" (zero-length string).
CommandTimeout Set or return a long integer value that indicates the time (in seconds) to wait for the command to execute. The default value is 30.
CommandType Iset o ibalik ang uri ng isang Command object.
Name Iset o ibalik ang pangalan ng isang Command object.
Prepared Nag-uusap kung mag-save ba ng nakikompile na bersyon ng command bago magsasalita (nakipag-iwas na bersyon).
State Ibentehin ang isang halaga, ang halagang ito ay maaring ilarawan ang estado ng Command object na buksan, sarado, nakakonekta, nagpapatupad o naka-retreive ng data.

Mga paraan

Mga paraan Paglalarawan
Cancel Ikansela ang isang pagpapatupad ng isang method.
CreateParameter Lumikha ng isang bagong Parameter object.
Execute Ipaliwanag ang pag-execute ng kwestyon, SQL statement o stored procedure sa atribute ng CommandText.

Koleksyon

Koleksyon Paglalarawan
Parameters Ang lahat ng Parameter na naglalaman ng isang Command object.
Properties Ang lahat ng Property na naglalaman ng isang Command object.