JavaScript Editor js editor     Web development 

Main Page

To store data blocks of any kind, such as null values, assembler code, printer drivers, and alphanumeric text of indeterminate length, or a reference to a data block in a field, use the Memo field type. To prevent data in Memo fields from being translated across code pages, use the Memo (Binary) field type.

To create a Memo (Binary) field, use the NOCPTRANS option in the SQL CREATE TABLE and CREATE CURSOR commands or select it in the Fields tab in the Table Designer.

Memo and Memo (Binary) fields contain a ten-byte reference to the actual contents of the memo. However, the actual size of memos depends on the amount of data you store in them. Data from Memo and Memo (Binary) fields from records in a table are stored in a separate file with the same name as the table and an .fpt file name extension. Memo and Memo (Binary) fields are limited only by the amount of available disk space.

You can store contents of Memo fields as memory-resident strings. You can then manipulate these strings with all functions that operate on character data.

For specifications about the Memo and Memo (Binary) field type, see Visual FoxPro Data and Field Types.

See Also

JavaScript Editor js editor     Web development