Path: utzoo!utgpu!news-server.csri.toronto.edu!mailrus!wuarchive!zaphod.mps.ohio-state.edu!usc!apple!uokmax!occrsh!abcom!mdb
From: mdb@abcom.ATT.COM (5013 )
Newsgroups: comp.databases
Subject: Re: dBase dbf stru modify
Message-ID: <2125@abcom.ATT.COM>
Date: 9 Aug 90 15:42:43 GMT
References: <116447@linus.mitre.org>
Distribution: usa
Organization: AT&T(IMS-DPO), Aurora, Colorado
Lines: 35

From article <116447@linus.mitre.org>, by cazier@mbunix.mitre.org (Cazier):
> Suppose I copy stru to test and then modi stru to fewer fields with the same
> field names and sizes. How do I append from the "fuller" .DBF to the modified
> .DBF just those fields with equal names and sizes? Is it required that I copy
> the specific data to another file "delimited" then append from delimited?

Just copy the data from the old structure to the new one, if the name,length,
and field type are the same that piece of data will be carried over into
the new database.

			E X A M P L E

OLD DATABASE                               NEW DATABASE
------------                               ------------
FNAME	CHARACTER	10                 FNAME	CHARACTER 	5
LNAME	CHARACTER	20 		   AMOUNT	CHARACTER	10
AMOUNT	INTEGER		5

	-----------------------------------------------------

COMMAND --> USE NEW
	    APPEND FROM OLD

RESULTS --->
FNAME: MICHAEL				FNAME: MICHA
LNAME: BARNES				AMOUNT: 0
AMOUNT: 100

	As you can tell if you shorten character fields the information 
	load into that field will be truncated.

/--------------\  Glump was an optimist ...
| Mike Barnes  |
| 415-224-5017 |
\--------------/