PRB: TOTAL Command Does Not Copy Memo Field to New Table

ID: Q129470

The information in this article applies to:

Microsoft FoxPro for Windows, version 2.6a

SYMPTOMS

The TOTAL command copies the field structure from the current table to the structure of the new table with the single exception of memo fields; all other field types are transferred. The "Language Reference" does not clearly state that the memo fields from the current table will not be included in the new table.

STATUS

This behavior is by design.

MORE INFORMATION

The TOTAL command (see the "Language Reference" page L3-1092) creates summary records in a new table or .DBF file with one record for each group of identically keyed records in the current table or .DBF file.

Steps to Reproduce Behavior

1. Type the following commands in the Command window:

   USE c:\fpw26\tutorial\salesman
   COPY to SALES1
   USE sales
   MODIFY STRUCTURE

2. Add a logical field, a general field, a float field, and a memo field if

   the table does not have an existing memo field.

3. Create an index on ONO.

4. In the COMMAND window, type these commands:

   TOTAL to NEWSALES on ONO
   SELECT 0
   USE NEWSALES

5. Compare the structure of the new table with the original. Verify that

   the MEMO field is the only field that does not exist in the new table.

Additional reference words: FoxWin 2.60a KBCategory: kbprg kbprb kbdocerr KBSubcategory: FxprgGeneral