Access 2007 VBA Programmer’s Reference phần 9

Chương 22 bao gồm thêm thông tin về an ninh vĩ mô như thế nào truy cập tăng cường bảo vệ cho các máy Và nó chắc chắn tiện dụng để sử dụng mã để tạo ra các tài liệu tùy chỉnh về mức độ bảo mật người dùng. | Appendix E ADO Object Model Reference Property DataType Description Dialect GUID Contains a GUID that represents the dialect of the command text or stream. Name String Identifies the Command object as a method on the associated Connection object. NamedParameters Boolean Indicates whether parameter names are passed to the provider. Prepared Boolean True if the provider should save a compiled version of a Command before execution. State Long Value that represents if the Command object is open closed or in the process of connecting executing or retrieving information. Methods of the Command Object Methods of the Command objects are used to work with a particular command that will be executed on the Connection object. To execute a Command object just call it by its Name property on the associated Connection object. Method Description Cancel Cancels the execution of an asynchronous call before it has completed. CreateParameter Creates a parameter for the Command object with the specified settings which are five optional parameters Name Type Direction Size and Value. Execute Executes the particular command stored in the CommandText property. Collections of the Command Object Collection Description Parameters Contains all the Parameter objects used for stored queries and stored procedures. Properties Contains all the Property objects for the current command object. 878 Appendix E ADO Object Model Reference Parameters Collection The Command object has a Parameters collection associated with it that contains all of the Parameter objects of the Command object. The actual Parameters collection does not contain any properties or collections only methods. Methods of the Parameters Collection There are exactly three methods for the Parameters collection. They are described in the following table. Method Arguments Description Append Parameter object Used to add a Parameter object to the collection. Refresh None Updates all of the Parameter objects in the collection with the .