SET RELATION TO [ <> INTO <>
[, <> INTO <> ]
[ADDITIVE] ]
, INTO, ().
- , , .
, ' , (4-,5-,), SET RELATION ADDITIVE.
SET RELATION TO .
kartotec, pos, pidr
| ||||||||
| ||||||||
| ||||||||
:
use pos
index on kod_pos tag k_pos
use pidr
index on kod_pidr tag k_pidr
procedure sv
sele 1
use kartotec
sele 2
use pos
set order to tag k_pos
sele 3
use pidr
set order to tag k_pidr
sele 1
set relation to kod_pos into pos && kod_pos kartotec pos
set relation to kod_pidr into pidr additive && kod_pidr kartotec pos
browse fields FIO: h=..., dol.nazv_dol: h=, podr.nazv_p: h=ϳ
---
SET SKIP TO [< 1> [, < 2>]]
.
, , .
SET RELATION, SET SKIP TO
Structure for database: D:\FOXPRO\PROB\DOGOVOR.DBF
Number of data records: 5
Date of last update: 12/07/97
Field | Field Name | Type | Width | Dec | Index |
N | Numeric | ||||
KOD_PR | Numeric | Asc | |||
KOD_TOV | Numeric | Asc | |||
KOL | Numeric | ||||
DATA | Date |
Structure for database: D:\FOXPRO\PROB\PREDPR.DBF
Number of data records: 2
Date of last update: 12/07/97
Field | Field Name | Type | Width | Dec | Index |
KOD_PR | Numeric | Asc | |||
NAME | Character | ||||
ADR | Character | ||||
R_S | Numeric |
|
|
Structure for database: D:\FOXPRO\PROB\TOVAR.DBF
Number of data records: 2
Date of last update: 12/07/97
Field | Field Name | Type | Width | Dec | Index |
KOD_TOV | Numeric | Asc | |||
NAME | Character | ||||
CENA | Numeric |
Master index: D:\FOXPRO\PROB\PREDPR.CDX TAG: KOD_PR
Master index: D:\FOXPRO\PROB\DOGOVOR.CDX TAG: KOD_PR
Master index: D:\FOXPRO\PROB\TOVAR.CDX TAG: KOD_TOV
Procedure SV2
Use predpr in a order kod_pr
use dogovor in b order kod_pr
use tovar in c order kod_tov
sele b
set relation to kod_tov into tovar
sele a
set relation to kod_tov into dogovor
set skip to dogovor
summa=0
browse fields name:h=ϳ,;
b.N:h= ,b.data:h=,;
c.name:h=,b.kol:h=ʳ,;
summa=b.kol*c.cena:h=
close data
ϳ | ʳ | ||||
12/12/97 | TV | 77.50 | |||
************ | 05/05/97 | IBM | 200.00 | ||
************ | 05/05/97 | TV | 108.50 | ||
05/05/97 | IBM | 140.00 | |||
************ | 07/07/97 | TV | 263.50 |
SQL:
SET ALTER TABLE < >
ADD FOREIGN KEY < > TAG < >
REFERENCES < >
:
ALTER TABLE < >
DROP FOREIGN KEY TAG <> SAVE
ֳ SQL
1. ., ., ., Visual FoxPro 5. . -.: , 1997.
2. . Microsoft Visual FoxPro 5.0
3. .. Visual FoxPro 6.0.-.:,2000-416.
4. . Visual FoxPro 5.: - .: , 1997.
5. foxtalk.newmail.ru
6. www.sourceoffsite.com
7. homepage.msn.com
- 1 5
- 2 29
- 3 48
- 4 74
... 86