COPY TO ARRAY Creates a Logical Element for Memo Field

ID: Q97061

The information in this article applies to:

• Microsoft FoxPro for Windows, versions 2.5 and 2.5a
• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a

SYMPTOMS

If the COPY TO ARRAY command is used on a database that contains one or more memo fields, a logical field will be created and initialized to .F. for each memo field in the array regardless of whether the memo field contains data.

CAUSE

This behavior occurs because the COPY TO ARRAY command does not copy the contents of a memo field into the array under any circumstances.

RESOLUTION

To work around this situation, do one of the following:

• Create a program that loops through the database, copying each memo field to the proper array element, one by one.

  -or-

• Use SCATTER MEMO TO <array name>, which copies the memo field into an array element; however, multiple records cannot be copied into the array with this method.

  -or-

• Copy each memo field to the proper array element using the SELECT INTO ARRAY command.

Last Reviewed: June 27, 1995