Objek Command ADO

Command object

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

If this query is used to retrieve data, the 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 Deskripsi
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 an empty 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 Menetapkan atau mengembalikan jenis objek Command.
Name Menetapkan atau mengembalikan nama objek Command.
Prepared Menunjukkan sama ada command disimpan sebelum pelaksanaan versi kompilasi (versi yang siap digunakan).
State Mengembalikan nilai, nilai ini dapat mendeskripsikan status objek Command yang terbuka, tertutup, terhubung, dieksekusi atau mengambil data.

Metod

Metod Deskripsi
Batal Batalkan eksekusi sekali daripada satu metod.
BuatParameter Membuat objek Parameter baru
Melaksanakan Melaksanakan kueri, perintah SQL atau prosedur simpan yang ada dalam sifat CommandText.

Kumpulan

Kumpulan Deskripsi
Parameter Semua objek Parameter yang mengandungi objek Command.
Properti Semua objek Property yang mengandungi objek Command.