Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving Old Table data to New Table File Structure
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00385162
Message ID:
00389585
Views:
12
>Hi Larry:
>
>D:\Newschd\Schd.dbf has all of my new addtional fields.
>
>D:\Schedule\Schd.dbf has all of my live data records.
>
>I would like to move all Schedule\Schd.dbf records into D:\Newschd\Schd.dbf table. Will scan work for this also?

Yes you can brute force it. Scan table1, seek on table2, if exist, replace values if needed. If it doesn't exist, insert a new record.

Note: Make sure the new fields allow NULL values or have default values assigned. If you attempt to add a new record from table1. the table2 fields without values will throw an error, otherwise.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform