How to Use OLE to Edit General Fields in Visual FoxPro

MORE INFORMATION

Step-by-Step Example

1. Create a table with a general field in it, and save the table.
2. When prompted to Input Data Records Now, click Yes. Double-click the general field to open it. On the Edit menu, click Insert Object. In the Object Type list, scroll down to the Paintbrush Picture item and select it. When Paintbrush appears, draw something in the paintbrush window. On the File menu in Paintbrush, click Exit to Return to <tablename.fieldname>. Click Yes in the window that appears to update the general field.
3. Close the general field by pressing CTRL+W. Add another record to the table and repeat step 2. This time select another application in the Object Type box. If the application is OLE 2 aware, editing will take place in the general field itself. Close the general field to save the data placed into it.
4. Close the Browse window of the table, and create a form. Choose the OLE Bound Control from the Forms Control toolbar, and place it on the form.
5. In the Properties sheet, type the name of the general field in the ControlSource property of the OLE Bound control.
6. To allow all of the data from the general field to fit into the OLE object of the form, select 1 or 2 in the Stretch property.
7. Place a command button on the form, and type the following code into its Click event:

      SKIP
      THISFORM.REFRESH
   							

8. Run the form, and double-click the general field. Note that Paintbrush appears allowing the picture to be edited. Make changes to the paintbrush picture, and close it. Click the command button, and then double-click the general field again. Note that the application used to place the data into the general field earlier appears again.