, Delphi - Database Desktop.
Database Desktop 䳿. , (Paradox, dBASE, Microsoft Access). , .
, , Tools Database Desktop Database Desktop. Database Desktop, ', File New , ', Table. Create Table, , ( Paradox 7).
Create Paradox 7 Table, .
', , , . ' . ' , Field Name, 25 .
, . . .1.
Alpha | A | . Size, 1255 | ||||||
Number | N | 10-307 10308 15- | ||||||
Money | $ | . . | ||||||
Short | S | ֳ -3276732767 | ||||||
Long Integer | I | ֳ -2 147 483 648-2 147 483 647 | ||||||
Date | D | |||||||
Time | , | |||||||
Time stamp | @ | |||||||
Memo | M | . Memo , Alpha. (1240) , . , ' ' , mb | ||||||
Formatted Memo | F | ( Memo). , | ||||||
Graphic | G | |||||||
Logical | L | "" (True) "" (False) | ||||||
Auto-increment | + | ֳ . , | ||||||
Bytes | Y | . , Database Desktop | ||||||
Binary | . , Database Desktop. Memo, . Binary, , audio- | |||||||
, , , ' < >.
|
|
. . , ( Alpha) Fam () , . Fam , , . , . Fam () Name ('). . , . , . , , Pasp ().
, , Key. , .
, , ' , Required Field. , , Fam () ' , Tel () .
, , , Minimum value (̳ ) Maximum value ( ) .
Default value , .
Picture , , . . . 17.2.
ϳ , , ' , . , #, . , ' .
, Tel ( ) , , , , , , . Picture : ###-##-##. Tel ' ( ), ' .
|
|
2. ,
* & @ *. | - ( ) - ( ) - ( ) - - ( , ) , " ", , - , , "" | ||
', , . , ' , . , [(###)]###-##-## , .
, . .
, Address { -, , }*@ [-, , ]*@, ' : , . ³ , , , ' , -, .
ϳ , , . Save As. Save Table As. Alias , , ' ' , .
Display table, Table, .
, , , . File Open | Table, Open, ', table Alias . , , . , , , Table Edit Data.
. <Enter>. , <Enter> .
, , , <F2> .
|
|
, , . Edit Preferences , ', General, Change. Change Font, . , Windows 2000 (Windows XP) Open Type, Database Desktop TrueType. TrueType. ϳ Database Desktop, .
. : , , .
, , . Data Access , Data Controls.
()
Database, Table, Query DataSource, Data Access BDE (.6).
.6. Data Access BDE
Database , , Table . DataSource ( ) ' - (, DBGrid) , ( Tbl) SQL- ( SQL). DataSource , , , DBGrid SQL- . 䳿 - DataSource . 17.7.
, , Table DataSource.
.5 Table, .6 DataSource. , .
5. Table
Name Database NameTable Name Table Type Active | ' . ' , ( ), . ' ( ), . Paradox (Paradox), dBase (ttDBase), FoxPro (FoxPro) (ttASCII). (). True | ||
ϳ DatabaseName TabieName . DatabaseName , TabieName - , .
|
|
.6. DataSource
Name | ' . | ||
DataSet | ' , | ||
DataSet ' , , , . . , , , , , . Table, DataSet.
. 7 8 Table DataSource , .
7. Table
Name | Table1 | ||
DatabaseName | Peterburg | ||
TableName | monuments. db | ||
Active | True | ||
8. DataSource
Name DataSet | DataSourcel Table1 | ||
'
. (master), (detail).
. Active=false. MasterSourse Table, , . ϳ MasterFields. ³ (Field Link Designer). Detail Fields , , . Master Fields . . Add, Joined Fields. Master Fields Table2 . ϳ (Active=True) .
. , -- . . ( ) , .
, , Data Controls (.8).
. 8.
, , , , , , .
DBText , DBEdit DBMm . .9 . , .
9. DBText, DBEdit DBM
Name DataSource DataField | ' . - , | ||
( " ' -", )
|
|
DBEdit DBM , " ' -". . 9.
. 9. ' -
11. DBEdit1 -DBEdit3 DBMemo1
DBEdit1 | DBEdit2 | DBEdit3 | DBMemo1 | |||
DataSource | DataSource1 | DataSource1 | DataSource1 | DataSource1 | ||
DataFieid | Monument | Architec | Photo | Note | ||
Active Tbl1 True, , DataFieid, DBEdit ' . , . Active Tabiei False, DBEdit ' ', Name.
- , image, , Label . Visible Image1, Label4 DBEdit3 False.
, , ' , .
, , DBNavigator, Data Controls (. 17.10). DBNavigator (. 17.11) , , , , , .