Program: Superbase Version: 2.0 Topic: Object Linking and Embedding Date: February 22, 1993 Summary: Object Linking and Embedding (OLE) is like Dynamic Data Exchange (DDE) in that it enables you to access objects that are stored in another product. However, instead of requesting data from another product, OLE lets you use the other product as if it were an extension of Superbase. Superbase can ONLY be an OLE CLIENT APPLICATION. It CANNOT be an OLE SERVER APPLICATION. There are two types of OLE objects that can be created in Superbase: embedded and linked. Embedded objects An embedded object contains a copy of the data in the server file. Once you embed an object, the data in the object no longer has any connection to the data in the server file from which it was copied. Any changes made to the object in Superbase are NOT reflected in the server application, and vice versa. Linked objects A linked object contains data that is linked to the server application and server file. When you link an object, it remains connected to the original data in the server file. Changes made to the object in Superbase ARE updated in the server application, and vice versa. To embedding a new OLE object, follow the steps below. 1. In Superbase, open a datafile that contains an external field. 2. Fill in the various fields, and when the cursor is positioned in the external field, click Edit\Insert embedded object. 3. A list of recognized servers appears. 4. Select a server. 5. In the Server application, prepare the object. You could also "paste" it from another object in the server application. 6. Exit; you must close the server application. 7. Answer "Yes" to update the embedded object. 8. In Superbase, complete and Save the data. To link objects, follow the steps below. 1. Start the server application. 2. Start Superbase. 3. In the Server application, load the existing object. Mark the object, and do an Edit\Copy. 4. Switch to Superbase, and when in the external field, select Edit\Paste special. This shows you a list of open servers. 5. Select the correct one for the server application. Select Paste link. 6. Fill in the rest of the data and then Save the Superbase record. Viewing OLE objects To view an embedded or linked OLE object, click the external file icon. This is the camera icon on the panel. (You could also choose Next External from the menus). The icon for the OLE object displays. Double-click the OLE object to view and edit it.