How to Append One Field to End of Another in Same Table

ID: Q114251

The information in this article applies to:

SUMMARY

You can take the values of one field and append records to the same table, putting those values into another field. The program below demonstrates this process using two character fields. If the field types were different, some data conversion would be necessary.

MORE INFORMATION

The following code example first opens the CUSTOMER database, then SELECTs the CITY field into a cursor named QUERY, with a field name of ADDRESS. It then SELECTs the original table, CUSTOMER, and appends the new records into it. The last two statements move the record pointer to 501 and browse the CUSTOMER table. Records 501-1000 now contain records 1-500 from the CITY field.

   SELECT City AS Address FROM Customer INTO CURSOR Query
   SELECT Customer
   APPEND FROM DBF('Query')
   GOTO 501
   BROWSE

REFERENCES

"Commands & Functions," version 2.0 (MS-DOS), pages C3-701-711, C3-136, and C3-274

"Language Reference," version 2.5 (Windows and MS-DOS), pages L3-862-874, L3-193, L3-356

Additional reference words: FoxMac FoxDos FoxWin 2.00 2.50 2.50a 2.50b 2.60 add adding join joining KBCategory: kbprg kbcode KBSubcategory: FxprgBrowse

Last Reviewed: June 27, 1995