, , . CASE- (CASE Computer-Aided System Engineering) ( ), . , , ERwin 3.0 - CASE- Logic Works, .
, ODBC-, , dBase- ( Windows).
.18. ODBC- Windows
ERwin, ODBC-. ERwin Tasks/Reverse Engineering.
, , , Erwin dBase 5.0 ( dBase ), , , . (dBase III, Clipper, FoxPro) . (, BLOB-), , , (, , ).
Clipper, , ( , ) , .19 ( dBase- , , C++Builder):
.19. CBUILDER\EXAMPLES\DATA
, , CLIENTS HOLDINGS, ACC_NBR CLIENTS IMAGE ( Column Editor ). "--" CLIENTS HOLDINGS, "" .
( Oracle). :
.20. Oracle
. "--", , Relationship Editor . . , CLIENTS ( HOLDINGS), , , .
|
|
.21.
Tasks/Forward Engineer/Schema Generation Oracle , . PL/SQL ( SQL, Oracle), DDL- (DDL Data Definition Language).
.22. DDL-
Data Migration Wizard , . . , , . , , (, , , - , ).
. (.23):
.23.
TBatchMove. . : Source ( ), , Destination , , Mapping ( ), Mode (batAppend , batUpdate , batCopy , , batDelete , ), KeyViolTableName ProblemTableName , - (, - ), ChangedTableName . Execute(). , TBatchMove.
:
|
|
Table1 | DatabaseName | Oracle7 |
Exclusive | true | |
TableName | CLIENTS | |
Active | true | |
Table2 | DatabaseName | BCDEMOS |
TableName | ClLIENTS.DBF | |
Active | true | |
DataSource1 | DataSet | Table1 |
DataSource2 | DataSet | Table2 |
DBGrid1 | DataSource | DataSource1 |
DBGrid2 | DataSource | DataSource2 |
DBNavigator1 | DataSource | DataSource1 |
DBNavigator2 | DataSource | DataSource2 |
BatchMove1 | Source | Table2 |
Destination | Table1 | |
Mode | batAppend | |
Button1 | Caption | CLIENTS |
Button2 | Caption | HOLDINGS |
Button3 | Caption | |
Button4 | Caption | |
Button5 | Caption |
:
//--------------------------------------------------------#include <vcl\vcl.h>#pragma hdrstop#include "upsize1.h"//--------------------------------------------------------#pragma link "Grids"#pragma resource "*.dfm"TForm1 *Form1;//--------------------------------------------------------__fastcall TForm1::TForm1(TComponent* Owner): TForm(Owner){}//--------------------------------------------------------void __fastcall TForm1::Button1Click(TObject *Sender){Table1->Close();Table2->Close();Table1->TableName="CLIENTS";Table2->TableName="CLIENTS.DBF";Table1->Open();Table2->Open();}//--------------------------------------------------------void __fastcall TForm1::Button2Click(TObject *Sender){Table1->Close();Table2->Close();Table1->TableName="HOLDINGS";Table2->TableName="HOLDINGS.DBF";Table1->Open();Table2->Open();}//--------------------------------------------------------void __fastcall TForm1::Button5Click(TObject *Sender){Table1->EmptyTable();}//--------------------------------------------------------void __fastcall TForm1::Button3Click(TObject *Sender){BatchMove1->Execute();}//--------------------------------------------------------void __fastcall TForm1::Button4Click(TObject *Sender){Close();}//--------------------------------------------------------. CLIENTS HOLDINGS . dBase (CLIENTS HOLDINGS) Oracle. , , HOLDINGS , CLIENTS. , (.24):
.24. detail- master-.
CLIENTS , HOLDINGS.
master-detail , .
, CLIENTS HOLDINGS, . (. 25):
.25. master- detail-.
ACC_NBR HOLDINGS. : ERwin , . - , , , CLIENTS. , , ( - ).
|
|
, , "integrity constraint" "key violation". , , , . CASE- , CASE- , .