How to Append One Field to End of Another in Same TableLast reviewed: June 27, 1995Article ID: Q114251 |
The information in this article applies to:
SUMMARYYou 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 INFORMATIONThe 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
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |