Q138649: How to Use OLE to Edit General Fields in Visual FoxPro

Article: Q138649
Product(s): Microsoft FoxPro
Version(s): 
Operating System(s): 
Keyword(s): 
Last Modified: 26-AUG-1999

-------------------------------------------------------------------------------
The information in this article applies to:

- Microsoft Visual FoxPro for Windows, version 3.0 
-------------------------------------------------------------------------------

SUMMARY
=======

Editing general fields is much easier in Visual FoxPro. A new control called the
OLE Bound Control is used to select general fields in the Form Builder and allow
editing of a general field when the form is running. The application used to
place the data into the general field when it was created is the application
that will appear on the screen when the form is running and you click the
general field to edit it.

For example, if you placed data into the general field by clicking Insert Object
on the Edit menu and then clicking Paintbrush, Paintbrush will appear when you
click the general field object of the form. Some applications that are OLE 2.0
aware, such as Microsoft Word or Microsoft Excel, will add their functionality
to the FoxPro menu, so you need only click the menu to change the data in the
general field object of the form.

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.

Additional query words: VFoxWin

======================================================================
Keywords          :  
Technology        : kbVFPsearch kbAudDeveloper kbVFP300

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 1986-2002.