Microsoft KB Archive/129470

{| = PRB: TOTAL Command Does Not Copy Memo Field to New Table =
 * width="100%"|

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
 * }