1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
SELECT Land_razd2.titul_id, Land_titul.titul_id, Land_titul.raion_id,;
Spr2.name, Land_titul.podr_id, Spr1.name, Land_titul.period_id,;
CAST(Land_titul.raschet_num AS I) AS raschet_num,;
IIF(Land_titul.raschet_num# 0 ,ALLTRIM(STR(Land_titul.raschet_num))+" óòî÷íåííûé","îñíîâíîé "),;
Land_razd2.r2_id, Land_razd2.r2_p010, Land_razd2.r2_p020;
FROM ;
landtax!land_titul ;
LEFT OUTER JOIN landtax!land_razd2 ;
ON Land_razd2.titul_id = Land_titul.titul_id ;
INNER JOIN dictionary!spr Spr1 ;
ON Spr1.ckod = Land_titul.podr_id ;
INNER JOIN dictionary!spr Spr2 ;
ON Spr2.ckod = Land_titul.raion_id;
WHERE ( ( ( Land_titul.raion_id = ( ?m.qRaionLand );
AND ( ?m.qRaionLand ) <> ( "Все" ) );
OR ( ?m.qRaionLand ) == ( "Все" ) );
AND ( ( Land_titul.podr_id = ( ?m.qPodrLand );
AND ( ?m.qPodrLand ) <> ( "Все" ) );
OR ( ?m.qPodrLand ) == ( "Все" ) ) );
AND ( ( ( Land_titul.raschet_num = ( ?m.qRaschetNumLand );
AND Land_titul.period_id = ( ?m.qPeriodLand ) );
AND ( ?m.qPeriodLand ) <> ( "Все" ) );
OR ( ?m.qPeriodLand ) == ( "Все" ) )
DBSetProp(ThisView,"View","SendUpdates",.T.)
DBSetProp(ThisView,"View","BatchUpdateCount", 1 )
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize", 100 )
DBSetProp(ThisView,"View","MaxRecords",- 1 )
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","UpdateType", 1 )
DBSetProp(ThisView,"View","UseMemoSize", 255 )
DBSetProp(ThisView,"View","Tables","landtax!land_razd2")
DBSetProp(ThisView,"View","WhereType", 3 )
DBSetProp(ThisView+".titul_id_a","Field","DataType","I")
DBSetProp(ThisView+".titul_id_a","Field","UpdateName","landtax!land_razd2.titul_id")
DBSetProp(ThisView+".titul_id_a","Field","KeyField",.F.)
DBSetProp(ThisView+".titul_id_a","Field","Updatable",.T.)
DBSetProp(ThisView+".titul_id_b","Field","DataType","I")
DBSetProp(ThisView+".titul_id_b","Field","UpdateName","landtax!land_titul.titul_id")
DBSetProp(ThisView+".titul_id_b","Field","KeyField",.F.)
DBSetProp(ThisView+".titul_id_b","Field","Updatable",.F.)
DBSetProp(ThisView+".raion_id","Field","DataType","C(20)")
DBSetProp(ThisView+".raion_id","Field","UpdateName","landtax!land_titul.raion_id")
DBSetProp(ThisView+".raion_id","Field","KeyField",.F.)
DBSetProp(ThisView+".raion_id","Field","Updatable",.F.)
DBSetProp(ThisView+".name_a","Field","DataType","V(50)")
DBSetProp(ThisView+".name_a","Field","UpdateName","dictionary!spr.name")
DBSetProp(ThisView+".name_a","Field","KeyField",.F.)
DBSetProp(ThisView+".name_a","Field","Updatable",.F.)
DBSetProp(ThisView+".podr_id","Field","DataType","C(20)")
DBSetProp(ThisView+".podr_id","Field","UpdateName","landtax!land_titul.podr_id")
DBSetProp(ThisView+".podr_id","Field","KeyField",.F.)
DBSetProp(ThisView+".podr_id","Field","Updatable",.F.)
DBSetProp(ThisView+".name_b","Field","DataType","V(50)")
DBSetProp(ThisView+".name_b","Field","UpdateName","dictionary!spr.name")
DBSetProp(ThisView+".name_b","Field","KeyField",.F.)
DBSetProp(ThisView+".name_b","Field","Updatable",.F.)
DBSetProp(ThisView+".period_id","Field","DataType","C(20)")
DBSetProp(ThisView+".period_id","Field","UpdateName","landtax!land_titul.period_id")
DBSetProp(ThisView+".period_id","Field","KeyField",.F.)
DBSetProp(ThisView+".period_id","Field","Updatable",.F.)
DBSetProp(ThisView+".raschet_num","Field","DataType","I")
DBSetProp(ThisView+".raschet_num","Field","UpdateName","landtax!land_titul.raschet_num")
DBSetProp(ThisView+".raschet_num","Field","KeyField",.F.)
DBSetProp(ThisView+".raschet_num","Field","Updatable",.F.)
DBSetProp(ThisView+".exp_9","Field","DataType","C(15)")
DBSetProp(ThisView+".exp_9","Field","KeyField",.F.)
DBSetProp(ThisView+".exp_9","Field","Updatable",.F.)
DBSetProp(ThisView+".r2_id","Field","DataType","I")
DBSetProp(ThisView+".r2_id","Field","UpdateName","landtax!land_razd2.r2_id")
DBSetProp(ThisView+".r2_id","Field","KeyField",.T.)
DBSetProp(ThisView+".r2_id","Field","Updatable",.F.)
DBSetProp(ThisView+".r2_p010","Field","Caption","Êàäàñòðîâûé ¹")
DBSetProp(ThisView+".r2_p010","Field","DataType","C(10)")
DBSetProp(ThisView+".r2_p010","Field","UpdateName","landtax!land_razd2.r2_p010")
DBSetProp(ThisView+".r2_p010","Field","KeyField",.F.)
DBSetProp(ThisView+".r2_p010","Field","Updatable",.T.)
DBSetProp(ThisView+".r2_p020","Field","DataType","C(10)")
DBSetProp(ThisView+".r2_p020","Field","UpdateName","landtax!land_razd2.r2_p020")
DBSetProp(ThisView+".r2_p020","Field","KeyField",.F.)
DBSetProp(ThisView+".r2_p020","Field","Updatable",.T.)
