. .
, (, , , , . .).
, , .
, , - . .
() , , . :
;
.
, .
dBase, FoxPro, Microsoft Access . .
, -.
InterBase, Oracle, Microsoft SQL Server . .
, (, "" "" - ). :
;
;
;
-.
() . , .
. .
, , .
- . , - . - .
relation () 70- IBM . , . , , , . .
|
|
, , , , - .
:
;
;
;
.
, . , .
, . , . .
.
. , , , .
:
;
;
.
60- . . : . , , , , (. 1).
. 1.
, .
, , , . .
. , (. 2).
. 2.
, . - .
( , relation ) 70- . , (. 3).
. 3.
. . .
, , , . , . , .
|
|
Windows . , , , . .
, , . , , . , . .
, . , (. 4).
, . :
;
;
.
. 4.
:
;
;
;
.
, Delphi.
, Delphi , , . , Delphi, :
DB2;
Informix;
InterBase;
Microsoft SQL Server;
Oracle;
Sybase.
, Delphi, :
Microsoft Access;
dBase;
FoxPro;
Paradox.
dBase Paradox. , . dBase . . , dBase, . 1 dBase .
1. dBase
*.dbf | |
*.dbt | (BLOB, Binary Large Object). , memo- OLE- |
*.mdx | , dBase |
*.ndx | He . |
dBase :
, ;
;
10.
2 dBase, Database Desktop .
2. dBase
Database Desktop | ||
Binary | , *.dbt. | |
Character | . 255 | |
Date | D | |
Float | F | -10308 10308. 15 |
Logical | L | () . : true () false () |
Memo | M | , *.dbt |
Number | N | - |
OLE | , OLE (Object Linking and Embedding) |
dBase . .
|
|
Paradox. dBase. Paradox , , . Paradox . 3.
3. Paradox
*.db | |
*.mb | (BLOB, Binary Large Object) |
*.px | ( ) |
*.xg* *.yg* | |
*.val | |
*.tv *.fam | Database Desktop |
*.net |
Paradox :
( ) , ;
, #, $ ;
( ) , |, Delphi;
25 ;
.
4 , Paradox, .
4. Paradox
Database Desktop | ||
Alpha | , 255 | |
Autoincrement | + | , . |
BCD | # | - |
Binary | . . 240 , *.mb | |
Bytes | Y | 255 |
Date | D | . 01.01.9999 . . 31. 12.9999 |
Formatted Memo | F | |
Graphic | G | : *.bmp, *.eps, *.gif, *.pcx, *.tif. *.bmp. *.mb |
Logical | L | : true false |
Longlnteger | I | . -2 147 483 648 2 147 483 647 |
Memo | M | . 240 , *.mb |
Money | $ | . Number , . |
Number | N | . -10307 10308. 15 |
OLE | , OLE. *.mb | |
Short | S | . -32 768 32 767 |
Time |
|
|
8. , .
- , , -;
- , ;
- ;
- .
:
;
;
-.
. , ( ). .
. . , , . , .
- . , , . , , , . . , , . , , , .
- , .
. , . , , - , . :
;
.
. . , .
, , , . SQL-, SQL-. , .
, . , , Delphi, Table Query, Query.
, , .
Delphi , . . , , . , , .
, . Delphi. , . , , ( ).
|
|
. .
Delphi . , Table, Query, StoredProc .
Delphi TDataSet, . , . TDataSet , () . , TDataSet . , TDataSet, -.
TDataSet TBDEDataSet. Borland Database Engine (BDE) Borland. BDE (DLL) , .
TBDEDataSet - TDBDataSet, , .
Delphi .
- Borland Database Engine (BDE) , , Delphi-. BDE .
- BDE Administrator BDE.
- Database Desktop , SQL- QBE.
- SQL Explorer , .
- SQL Builder SQL-.
- SQL Monitor SQL- .
- Data Pump .
- IBConsole .
- InterBase Server Manager InterBase.
- SQL Links , Microsoft SQL Server Oracle. InterBase, Delphi , BDE, SQL-Links.
- dbExpress SQL , SQLConnection, SQLDataSet, SQLQuery, SQLStoredProc SQLTabie.
dbExpress :
- InterBase DBEXPINT.DLL;
- DB2 DBEXPDB2.DLL;
- Oracle DBEXPORA.DLL;
- MySQL DBEXPMYS.DLL.
- InterBase Server InterBase.
. Delphi 6 IBConsole InterBase Windows Interactive SQL (WISQL), .
InterBase Server Manager (Local InterBase Server) (InterBase Server for Windows 95) SQL- Borland InterBase.
, , BDE Administrator SQL Explorer, , , , IBConsole .