, , . , .
1. :
a. DM:
- TZTable (Name = Nakladn; TableName = NAKL; MasterSource = DSPokup; MasterFields = IDPOKUP; LinkedFields = IDPOKUP),
- TDataSource DSNakl DSOtpusk;
- TZQuery (Name=Otpusk) TZUpdateSQL (Name=OtpUpdSQL)
b. :
- TDBText (DataSource=DM.DSPokup; dataField = POKUPNAME).
- TDBNavigator (DataSource=DM.DSPokup)
- DBGrid TDBNavigator, DataSource = DM.DSNakl DataSource = DM.DSOtpusk .
Nakladn Pokupatel.
TZQuery TableName , SQL UpdateObject.
2. UpdateObject OtpUpdSQL.
ZQuery . UpdateObject (UpdateObject:= null), ZQuery .
SQL TStrings , . 18:
18. SQL ZQuery
3. SQL , . 18
SQL :
where NAKLNOM =: NAKLNOM
:NAKLNOM NAKLNOM, Object Inspector (. 19).
4. DataType=ftInteger, ParamType=ptInput, Size=4 NAKLNOM , .
: .
(NAKLNOM) , Master Detail, , TZTable. , , TZQuery.
TZQuery Otpusk , InsertSQL, ModifySQL, DeleteSQL RefreshSQL. SQL TZQuery Otpusk, :
5. DM TZUpdateSQL OtpUpdSQL , UpdateSQL Editor. :
20. DML ZUpdateSQL
OTPUSK : IDTOV NAKLNOM. Key Fields, Update Fields . "Generate SQL". SQL , , . 21:
|
|
21. ZUpdateSQL
, ,
, . , NAKL OTPUSK , . 22:
22.
1. :
, . , .
124 | ||||
: | ||||
10.02.2002 | "" | . , . ,35, . 23-71-63 | ||
. . | , . | |||
4,78 | ||||
3,15 | ||||
1,40 | ||||
- | 1,67 | 133,6 | ||
5,15 | 51,5 | |||
732,1 |
125 | ||||
: | ||||
14.02.2002 | "" | . , . , 25, . 68-77-86 | ||
. | , . | |||
4,78 | 382,4 | |||
3,15 | ||||
1,40 | ||||
- | 1,67 | 350,7 | ||
5,15 | 257,5 | |||
1634,6 |
126 | ||||
: | ||||
15.02.2002 | "" | . , . ,35, . 23-71-63 | ||
. | , . | |||
4,78 | 382,4 | |||
3,15 | ||||
1,40 | ||||
- | 1,67 | |||
5,15 | 257,5 | |||
1205,9 |
127 | ||||
: | ||||
16.02.2002 | "" | . , . , 45, . 46-87-883 | ||
. | , . | |||
4,78 | 573,6 | |||
3,25 | ||||
1,40 | ||||
8,75 | ||||
5,80 | ||||
1600,6 |
128 | ||||
: | ||||
16.02.2002 | "" | . , . , 45, . 46-87-883 | ||
. . | , . | |||
3,78 | 453,6 | |||
3,25 | ||||
1,40 | ||||
8,75 | ||||
1,80 | ||||
1220,6 |
:
1. .., .., . . . ER - . . , 2008
2. .., . . . InterBase. . , 2008
3. .., . . . . , 2005