1.Task for the laboratory work.
2.1. Build-in FoxProw commands
3. Practical usage of data of data transfer.
4. Technical facilities & literature used.
1. Task for the laboratory work.
The aim of this work is to show our ability to work with different Microsoft applications & to produce the data exchange between them, using build-in commands, OLE instruments & other possible facilities.
In the practical examples we will show the data transfer process using the following Microsoft Applications: FoxPro, Excel & Word.
Also it is necessary to present the theory about the data transfer for it is impossible to use all of them in the examples.
2. Theory part.
There are several different ways to transfer data from FoxPro to different Microsoft Applications & vice versa.
2.1. Built-in FoxPro commands.
Operator can use several built-in commands of FoxPro such as Export, Import, Copy and Append from.
Now we would like to present some helpful information about these operands.
The format of EXPORT is:
EXPORT TO <file>
[FIELDS <field list>]
[[TYPE] DIF | MOD | SYLK | WK1 | WKS | WR1 | WRK | XLS]]
Use EXPORT to use FoxPro data in other software packages.
If the table/.DBF you are exporting from is indexed, the new file created is created in the indexed order.
Include the name of the file to which FoxPro exports data. If you do not include an extension with the file name, the default extension for the specified file type is assigned.
FIELDS <field list>
Include FIELDS <field list> to specify which fields are copied to the new file. If the FIELDS clause is omitted, all fields are copied to the new file. Memo and general fields are not copied to the new file even if their names are included in the field list.
The scope clauses are: ALL, NEXT <expN>, RECORD <expN>, and REST. These are explained in the Overview of the FoxPro Language chapter in the FoxPro Language Reference. Commands which include <scope> operate only on the table/.DBF in the active work area.
You can specify a scope of records to copy to the new file. Only the records that fall within the range of records specified by the scope are copied to the new file.
The default scope for EXPORT is ALL records.
If the FOR clause is included, only records that satisfy the logical condition <expL1> are copied to the new file. Including the FOR clause lets you conditionally copy records, filtering out undesired records.
Rushmore optimizes an EXPORT ... FOR <expL1> command if <expL1> is an optimizable expression. For best performance, use an optimizable expression in the FOR clause. A discussion of Rushmore optimizable expressions appears in the Optimizing Your Application chapter in the FoxPro Developer's Guide.