Integration of VFP with other applications_PHP tutorial-PHP Tutorial-php.cn

Integration of VFP with other applications_PHP tutorial

WBOY

Release： 2016-07-21 16:10:17

Original

809 people have browsed it

As a database software, Visual FoxPro 5.0 not only has the function of managing its own data, but can also be integrated with other applications to obtain data provided by other applications. In addition, through Visual FoxPro 5.0, you can also merge data in tables or views with Microsoft Word documents, generate mail merge documents, or embed or link other OLE objects through universal fields.
1. Import data
The so-called importing data means copying data from another application, then creating a new table in Visual FoxPro 5.0, and filling the table with data from the source file. In Visual FoxPro 5.0, you can import data from multiple file types.
If you want to use tables from FoxPro or dBASE files, you can open and use them directly without importing. Visual FoxPro 5.0 will ask you if you want to convert the table to Visual FoxPro 5.0 format. Once a table is converted from a previous version to the latest version, it can no longer be opened with the previous version. When importing data, you can use either the Import Wizard or the Import dialog box.
2. Append data to an existing table
When performing an import operation, in addition to importing data into a new table, you can also import it into an existing file. When you choose to import data into an existing file, Visual FoxPro 5.0 will append the data to the end of the existing file.
In addition to using the "Import Wizard" to append the data to be imported to an existing file, you can also use the "Append Source" dialog box to append data. When appending data using the Append From dialog box, you should first open the table to which you want to append records from the Browse window. By default, Visual FoxPro 5.0 appends all records and fields in the source file to the currently open table, but using the "Append From" option, you can specify which fields or records to append.
3. Export data
In Visual FoxPro 5.0, you can not only import or append data from other applications, but also export the data stored in the Visual FoxPro 5.0 table to a file in another format. For use by other applications. The so-called export refers to copying data from a Visual FoxPro 5.0 table to a file used by other applications. In a Visual FoxPro 5.0 database, data can be stored in a variety of file types.
In Visual FoxPro 5.0, you can export data using the Export dialog box. When exporting data, you can export all fields and records in the specified table, or only a part of them. Users can define which fields and records are to be exported.
4. Create a mail merge file
We know that using the "Mail Merge" function in the "Tools" menu in Word can link a list of standard text and single information into a new document, including form letters, Addressed envelopes, emails and faxed documents. In Visual FoxPro 5.0, you can also use the "Mail Merge Wizard" to complete the above functions.
The "Mail Merge Wizard" actually integrates Visual FoxPro 5.0 and Microsoft Word applications, allowing Microsoft Word to share data contained in Visual FoxPro 5.0 tables or views, and use these data to print a batch of the same format documentation. In daily life, this method is very useful.
5. Embed or link OLE objects
The above methods can only enable Visual FoxPro 5.0 to statically share data generated by other applications. To be able to dynamically share data generated by other applications, Visual FoxPro 5.0 also provides methods for embedding or linking data. Embedding and linking data is accomplished through universal fields, which allow users to embed or link data from other applications in tables or forms while still maintaining the data with those applications. In Visual FoxPro 5.0, external data is generally embedded or linked in tables or forms.