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

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