Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compare two databases for different
Message
From
25/02/1997 12:43:05
 
 
To
25/02/1997 12:33:46
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00021960
Message ID:
00021965
Views:
27
>I must be making this harder than it is. I want to compare two databases to each other. The records in database #A that are not contained in database #B I want these records moved to a database #C. I will print this as updated list and append the updated records to database #A. I have been creating pure code and the project is going slow. The records however are still coming in and not being updated. If anyone could offer an overview / exact example that can be easier than pure code let me know.Thanks

Let say that tables "A" and "B" have primary key 'Id'. Then following statement will select records from A, non-contained in B, and put them in newly created table C :
SELECT * From A Into Table C Where Id NOT IN (SELECT Id From B)

Now you can REPORT FORM and then APPEND.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform