Иностранный язык / Реферат: Task for the laboratory work

Реферат: Task for the laboratory work

RPD

RPD files are created by RapidFile version 1.2. RPD file names are assumed to have an RPD extension.

SDF

An SDF (System Data Format) file is an ASCII text file in which records have a fixed length and end with a carriage return and a line feed. Fields are not delimited. The file name extension is assumed to be .TXT for SDF files.

WK3

Data from a Lotus 1-2-3 spreadsheet. Each column from the spreadsheet becomes a field in the table; each spreadsheet row becomes a record in the table. A .WK3 file name extension is assigned to a spreadsheet created in Lotus 1-2-3 revision 3.x.

2.2. OLE.

Another method of data exchange between not only FoxPro but between all Windows based applications is OLE (OBJECT LINKING AND EMBEDDING)

First you can use a FoxPro built in command Append General.

APPEND GENERAL <general field> FROM <file>

[LINK]

[CLASS <ole class>]

APPEND GENERAL is supported in FoxPro for Windows only.

If an OLE object already exists in the general field, it is replaced with the OLE object from the file.

Clauses

Include <general field> to specify the name of the general field the OLE object is placed in. You can specify a general field in a table open in a noncurrent work area by including the table alias with the field name.

<file>

Include <file> to specify the file containing the OLE object. You must include the entire file name, including its extension. If the file is located in a directory other than the current default directory, include the path with the file name.

LINK

If LINK is included, a link is created between the OLE object and the file that contains the object. The OLE object appears in the general field but the object's definition remains in the file. If LINK is omitted, the OLE object is embedded in the general field.

CLASS <ole class>

Include the CLASS clause to specify an OLE class for an OLE object other than the default class.

Tip To determine the class for an OLE object, run REGEDIT and double-click on the OLE object. The class name is listed under Identifier.

You can specify a class name when the file extension for the file containing the OLE object is different than the default extension and you want to force the behavior for the class. If the default extension can be used by multiple OLE servers, include the class to specify a particular server.

3. Practical usage of data transfer.

In applications you can find the examples of the above mentioned commands usage and their results in different Microsoft Applications (FoxPro, Word & Excel).