APPEND FROM Command Appends Blank Records

ID: Q95676

The information in this article applies to:

• Microsoft FoxPro for Windows, versions 2.5 and 2.5a
• Microsoft FoxPro for MS-DOS, versions 1.02, 2.0, 2.5, and 2.5a
• Microsoft FoxBASE+ for MS-DOS, version 2.1

SUMMARY

To append from one database to another, the fields in the source database must have the same names as the fields in the target database. Otherwise, blank records will be appended to the target file.

For example, if TEST_A.DBF has a field called NAME and TEST_B.DBF has a field called NICKNAME, the following code will append blank records to TEST_A:

   USE TEST_A
   APPEND FROM TEST_B

To work around this problem, do one of the following:

• Modify the structure of TEST_B to change "NICKNAME" to "NAME".

  -or-

• Use the COPY TO ... TYPE DELIMITED command to first copy the records in TEST_B.DBF to a delimited ASCII text file, and then use the APPEND FROM ... TYPE DELIMITED command to append the records from the text file to TEST_A.DBF.

Last Reviewed: June 27, 1995