What is the ole object in the database?

The ole object in the database is integrated with desktop applications, and also defines and implements a mechanism that allows applications to "connect" to each other as software "objects" (data collections and functions that operate data). This This connection mechanism and protocol is called the Component Object Model, or COM for short.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Access 2013 version, Dell G3 computer.

Object Linking and Embedding, Object Linking and Embedding, referred to as OLE technology. OLE is not only desktop application integration, but also defines and implements a mechanism that allows applications to "connect" to each other as software "objects" (data collections and functions that manipulate data). This connection mechanism and protocol are called components Component Object Model, referred to as COM. OLE can be used to create compound documents. Compound documents contain different types of data created in different source applications, so it can combine text, sounds, images, tables, etc. together.

OLE is a comprehensive set of standards for transferring and sharing information between client applications. A protocol that allows the creation of hybrid documents with links to applications so that users do not have to switch between applications when making modifications. OLE is based on the Component Object Model (COM) and allows the development of reusable plug-and-play objects that can interoperate among multiple applications. The protocol has been widely used in business, where spreadsheets, word processors, financial software packages, and other applications can share and link individual information through a client/server architecture

OLE is an object-oriented technology that enables the development of reusable software components (COM).

Extended information:

OLE class, file, project

OLE class decides to create OLE The object's server. Some applications need to create multiple types of OLE objects, such as applications that simultaneously link or embed formulas, pictures, etc. The OLE class also determines the data type contained in the OLE object. Linked or embedded objects must define the OLE class.

OLE file is a source file containing OLE object data. Linked objects must use object files because linked objects are saved in files. OLE files are also used if the application creates embedded objects from existing source files. For example, if the

OLE object TUTOR.WBI linked to a QuattiPro notebook is stored in the D:\DFFICE\QPW directory, the OLE file is D:\DFFICE\QPW\TUTOR.WBI. It is worth noting that OLE files can only be defined for linked objects, and for embedded objects, only OLE classes need to be defined.

OLE project is a portion of an OLE file that represents linked or embedded data. OLE projects must be used when an application wants an OLE object to contain smaller blocks of data than an OLE file.

The menu of OLE application

The menu of OLE application is generally consistent with the main menu of other applications. If the application has an OLE 2.0 object that supports local activation , then menu fusion is required. Check the OLE server's information to find out whether the server supports local activation.

The GroupIndex attribute of the OLE application menu determines the location of the fusion menu, that is, whether the fusion menu replaces the main menu or is inserted into the main menu of the application.

OLE toolbars and status bars

When an OLE object is activated locally, the OLE server will attempt to replace the OLE application's toolbars and status bars with its own. If your application wants to be activated locally, you should write the corresponding code in the application to let the server use the toolbar and status bar. To do this, you must:

• Set toolbars and status bars

• Add status bars to the application

Create toolbars and status bars by modifying the properties of panel components. When an OLE object is activated locally, the panel or other alignment control coordinates with the OLE server program. This means that the OLE server can replace any alignment control in an OLE application form, but locked controls cannot be replaced. For example, if the align attribute of the panel is alTop, alleft, alBottom, alIngh, the control is not locked and the OLE server can replace it. To prevent the application's toolbar and status bar from being replaced, set the locked attribute to true.

OLE Automation

OLE Automation is a mechanism for a Windows application to manipulate another program. The program being automated is called an automation object or automation server, such as Word, and the application that operates or automates other programs is called an automation controller or automation client [2] . Using the idea of ​​OLE automation, the interaction between two Web application systems can be realized. OLE 2.0 provides a way to integrate applications, which is command operations between applications.

Using OLE 2.0, programmers can define a set of commands to enter them into other programs. These commands can take parameters. It looks very much like the application is calling a function or procedure. Using the above method, the interaction between two applications can be achieved without human participation. The program being automated is called an automation object or automation server, and the application program that operates or automates other programs is called an automation controller or automation client.

Recommended tutorial: "sql video tutorial"

The above is the detailed content of What is the ole object in the database?. For more information, please follow other related articles on the PHP Chinese website!