1. , . , , .
2. , . , .
3. , :
!
4. , , , . , .
5. , : .
6. , , ( ).
7. : , : , .
7 (10 ).
. , , . , - .
, , - , . , , . Paradox 7.
. : , , , . -, . : , , , .
Database Desktop, . , 3 , Delphi.
|
|
' . . 24. , 4 : , ,
. 24.
-, . , . Author Name , User . - ID. .
- ID Autoincrement, , . Alpha )'. . , , .
Database Desktop, Delphi. Ÿ Delphi Tools {Database Desktop. Filej Working Directory... , . , Delphi.
FiJe|New|Table... 3 , , , . , , (. 25) . Paradox 7, .. .
Paradox 7, . . 25. Database Desktop , Books.db. , . , . Alpha , Long Integer , + (Autoincrement).
. 25. Database Desktop
. . , .
, . . () .
|
|
. Books.db 2 , , - User . Secondary Indexes. . Define, (. 27).
. 27. Database Desktop
, , . , . . , . , , Index. Typelndex.
, User. UserIndex.
Database Desktop File|Open]Table, -ble|Restructure...
Delphi.
Delphi bl, Database Access . 3 , . 1.
1. bl
DatabaseName | String | , Database, - BDE Administrator , DBase, FoxPro Paradox |
TableName | String | |
Active | Boolean | . Open, - Close |
( ): (Data Module), File! New... bl, .
. 29.
TTable , . - . , . TTable, .
Fields. , TTable. , , . - , Add all fields . New field...
TableBooks TableTypesLookup TableUsersLookup. (lookup) : .
|
|
. 29 LookupType, - TableTypesLookup.
2. Field
Alignment | TAligranent | : , | |
DisplayLabel | String | , , , | |
DisplayWidth | Integer | ||
FieldKind | TFieldKind | , (f kData), (f kLookup), (fkCalculated) .. | |
FieldName | String | fkData, | |
Readonly | Boolean | ||
Required | Boolean | ||
Visible | Boolean | ||
LookupDataset | TDataset | ( ), | |
KeyFields | String | , , | |
LookupKeyFields | String | ||
LookupResultField | Spring | , |
ble TField. , . TField . 2.
. 30.
, . Delphi , TDataSource, , , . Delphi, , TDB, , BGrid , TDBNavigator .. . 30. , , ( , ) TDataSource Dataset.
. 31.
. 31.
. 32.
. 31. TDBGrid . , Insert, Ctrl+Delete. TDBNavigator, , , . -. - DataSource - . .. , , ( ) ( ). Delphi File|Use Unit..., uses implementation .
|
|
, , . 32. , Data, DataSource. , , ID . Visible False.
, . : , , . Delphi .
Filter Filtered TTable. , Type<>l and Author='*' , 1 ' '.
- (master-detail) . , . , : TableBcoks, - TableTypes HTableUsers.
, , , TableTypes Tablellsers , a TableBooks - . . , . 24.
24. ble
. | ||
MasterSource | TDataSource | |
IndexFieldNames | String | , |
MasterFields | String | , |
, . -, MasterSource, IndexFieldNames MasterFields TableBooks. - TDBLookupComboBox, TableTypes TableUsers. TDBLookupComboBox ListSource DataSourceType ( DataSourceUsers); ListFields Booktype ( UserName) KeyField ID.