Shulou(Shulou.com)06/02 Report--

In this issue, the editor will bring you an analysis of how to carry out the ADO MD object model. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

Use the Description property to get a short error description. Display this property to warn the user of errors that you cannot or do not want to handle. The string will come from either the ADO MD or the provider, which won't work. You are locked out of IDE, so you can only write code line by line, right?

ADO and ADO MD are interrelated but independent object models. The objects provided by ADO are used to connect to data sources, execute commands, retrieve tabular data and schema metadata in tabular format, and view provider error messages. The objects provided by ADO MD are used to retrieve multidimensional data and view the metadata of multidimensional schemas.

When using MDP, you can choose to use ADO or ADO MD in your application, or both. If you reference two libraries in the project, the user will have full access to the features provided by MDP.

In general, it is useful for users to get a flat tabular view of a cube. You can do this by using the ADO Recordset object. Specify the source of the Cellset as the Source parameter of the Recordset Open method, not the source of the ADO MD Cellset.

It would also be helpful to view schema metadata in a tabular view rather than as an object hierarchy. The ADO OpenSchema method of the Connection object allows the user to open a Recordset that contains schema information. The QueryType parameter of the OpenSchema method contains several SchemaEnum values that are specific to the MDP. These values are:

◆ adSchemaCubes

◆ adSchemaDimensions

◆ adSchemaHierarchies

◆ adSchemaLevels

◆ adSchemaMeasures

◆ adSchemaMembers

To use ADO enumerated values with ADO MD properties or methods, you must reference both the ADO library and the ADO MD library in the project. For example, you can use ADO adState enumerated values through the ADO MD State property. For more information about creating library references, see the documentation for the development tool. To use ADO enumerated values with ADO MD properties or methods, you must reference both the ADO library and the ADO MD library in the project. For example, you can use ADO adState enumerated values through the ADO MD State property. For more information about creating library references, see the documentation for the development tool.

The above is the analysis of the ADO MD object model shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.