Microsoft KB Archive/97061

{| = COPY TO ARRAY Creates a Logical Element for Memo Field =
 * width="100%"|

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, 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.

Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a KBCategory: kbprg KBSubcategory: FxprgGeneral
 * }