Path: utzoo!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!usc!hacgate!ashtate!dbase!awd
From: awd@dbase.UUCP (Alastair Dallas)
Newsgroups: comp.databases
Subject: Re: Simple File Transfer
Summary: APPEND FROM solves the problem
Message-ID: <316@dbase.UUCP>
Date: 5 Dec 89 23:19:54 GMT
References: <2576D91B.25986@paris.ics.uci.edu>
Organization: Ashton Tate Devlopment Center Glendale, Calif.
Lines: 20

In article <2576D91B.25986@paris.ics.uci.edu>, ajauch@bonnie.ics.uci.edu (Alexander Edwin Jauch) writes:
> I have what I considered to be a trivial problem.
> ...how in the hell do I add fields to a 
> database once it has been defined????
> 

Sorry that this is not more obvious; it is, however, very easy to do.  If 
you have a dbf file with fields a,b,c and you want to add d and e, just:

	CREATE Temp  && with fields a,b,c,d,e
	USE Temp
	APPEND FROM Master

Temp.dbf now contains the data in the original master file with the extra
fields added.  Note that the ordering of fields in Temp is not important,
but the exact names are--only fields with the same names are copied.

Hope it helps.

/alastair/