APPEND FROM <File> FOR Clause Requires Common Field

ID: Q117593

The information in this article applies to:

• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5x, 2.6
• Microsoft FoxPro for Windows, versions 2.5x, 2.6
• Microsoft FoxPro for Macintosh, versions 2.5x, 2.6a

SUMMARY

When the APPEND FROM <file> command is used with the FOR clause, the conditions specified in the FOR clause must be met; in addition, if you are adding corresponding field values between tables, both files must contain identical field names.

MORE INFORMATION

When the APPEND FROM <file> command is used with the FOR clause, FoxPro performs two evaluations for adding records to the target file. Only records that both meet the FOR condition and contain identical field names in both the source and target files are added to the target file; records that do not meet one or both of these conditions are ignored during the APPEND request.

The following code example illustrates this behavior. In this example, records that contain the letter "C" in the company name are added from the CUSTOMER file to the ABC file. However, note that only those records that both meet the FOR clause and contain identical field names are added to the ABC file.

Sample Code

   SET DEFAULT TO SYS(2004)+"\Tutorial"
   USE Customer
   DISPLAY STRUCTURE
   *
   * Show current structure of CUSTOMER file
   *
   Structure for table:          c:\foxprow\tutorial\customer.dbf
   Number of data records:       60
   Date of last update:          05/26/94
    Field  Field Name      Type            Width      Dec    Index
        1  CNO             Character           5
        2  COMPANY         Character          35
        3  CONTACT         Character          20
        4  ADDRESS         Character          30
        5  CITY            Character          15
        6  STATE           Character           2
        7  ZIP             Character           5
        8  PHONE           Character          12
        9  ONO             Character           1
       10  YTDPURCH        Numeric             8        2
       11  LAT             Numeric             7        4
       12  LONG            Numeric             8        4
   ** Total **                               149
   *
   *
      SELECT Customer
      USE
      USE ABC
      DISPLAY STRUCTURE
   *
   * Show current structure of ABC file
   *
   *
   Structure for table:          c:\foxprow\tutorial\abc.dbf
   Number of data records:       60
   Date of last update:          05/26/94
    Field  Field Name      Type            Width      Dec    Index
        1  CNO_A           Character           5
        2  COMPANY         Character          35
        3  CONTACT         Character          20
        4  ADDRESS_A       Character          30
        5  CITY_A          Character          15
        6  STATE_A         Character           2
        7  ZIP_A           Character           5
        8  PHONE_A         Character          12
        9  ONO_A           Character           1
       10  YTDPURCHA       Numeric             8        2
       11  LAT_A           Numeric             7        4
       12  LONG_A          Numeric             8        4
   ** Total **                               149

   * Note that the COMPANY and CONTACT fields are common to both the
   * CUSTOMER and ABC files.

   * Program Example
      APPEND FROM SYS(2004)+"\tutorial\customer" FOR company = "C"

   * NOTE: Only CUSTOMER records containing a "C" in the COMPANY field are
   * added to the ABC file based on the common fields (COMPANY and CONTACT)
   * found in both the ABC and CUSTOMER files.

Last Reviewed: June 27, 1995