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.
SELECT Tablevist.id_vist, Tablevist.name_vist, Tableplace.nazv_pl,;
Tableorg.name_org, Tableplace.id_pl, Tableorg.id_org;
FROM ;
db!tableplace ;
INNER JOIN db!tablevist ;
ON Tableplace.id_pl = Tablevist.id_pl ;
INNER JOIN db!tableorg ;
ON Tableorg.id_org = Tablevist.id_org;
ORDER BY Tablevist.id_vist
DBSetProp(ThisView,"View","SendUpdates",.F.)
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","WhereType", 3 )
DBSetProp(ThisView+".id_vist","Field","DataType","I")
DBSetProp(ThisView+".id_vist","Field","UpdateName","db!tablevist.id_vist")
DBSetProp(ThisView+".id_vist","Field","KeyField",.F.)
DBSetProp(ThisView+".id_vist","Field","Updatable",.F.)
DBSetProp(ThisView+".name_vist","Field","DataType","C(30)")
DBSetProp(ThisView+".name_vist","Field","UpdateName","db!tablevist.name_vist")
DBSetProp(ThisView+".name_vist","Field","KeyField",.F.)
DBSetProp(ThisView+".name_vist","Field","Updatable",.F.)
DBSetProp(ThisView+".nazv_pl","Field","DataType","C(20)")
DBSetProp(ThisView+".nazv_pl","Field","UpdateName","db!tableplace.nazv_pl")
DBSetProp(ThisView+".nazv_pl","Field","KeyField",.F.)
DBSetProp(ThisView+".nazv_pl","Field","Updatable",.F.)
DBSetProp(ThisView+".name_org","Field","DataType","C(20)")
DBSetProp(ThisView+".name_org","Field","UpdateName","db!tableorg.name_org")
DBSetProp(ThisView+".name_org","Field","KeyField",.F.)
DBSetProp(ThisView+".name_org","Field","Updatable",.F.)
DBSetProp(ThisView+".id_pl","Field","DataType","I")
DBSetProp(ThisView+".id_pl","Field","UpdateName","db!tableplace.id_pl")
DBSetProp(ThisView+".id_pl","Field","KeyField",.F.)
DBSetProp(ThisView+".id_pl","Field","Updatable",.F.)
DBSetProp(ThisView+".id_org","Field","DataType","I")
DBSetProp(ThisView+".id_org","Field","UpdateName","db!tableorg.id_org")
DBSetProp(ThisView+".id_org","Field","KeyField",.F.)
DBSetProp(ThisView+".id_org","Field","Updatable",.F.)
