>I would like to move old D:\Schedule\Schd.dbf to D:\Newschd\Schd.dbf.
>Which copy command would do the job?
>
>1. I want this command to overlay the current data records in D:\Newschd\Schd.dbf.
If the structrures are similar, that is, if the field names are the same and the data types are the same with precision the same or greater in the new file then:
use D:\Newschd\Schd.dbf exclusive
zap
append from D:\Schedule\Schd.dbf
If the structures are not similar then you have to run through D:\Schedule\Schd.dbf using something like scan...endscan and manually insert the records into D:\Newschd\Schd.dbf (after zapping it). With this technique, you could perform any transformations you need to on the old data to make it conform to the new structure.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao