lign=center> FIO
N_t
В
ZONA Таблиця 3.
N_Z
Tar
В
Plata Таблиця 4. tabletable border=0 cellspacing=0 cellpadding=0>
AV
DOLG
DATA_V
N_T
N_Z
В
Razg Таблиця 5.
t
Br
Data-razg
N_z
N_t
В
5. СТРУКТУРА МЕНЮ
p align=center> 6. Лістинг МЕНЮ
Z 4.PRG
clear
set safe off
set talk off
close database
define menu ats bar at line 3
define pad x1 of ats prompt "запити 1-3"
define pad x2 of ats prompt "дані"
define pad x3 of ats prompt "вихід"
on pad x1 of ats activ popup xx1
on pad x2 of ats activ popup xx2
on pad x3 of ats quit
define popup xx1 from 4,1 to 11,11
define bar 1 of xx1 prompt "запит 1"
define bar 2 of xx1 prompt "запит 2"
define bar 3 of xx1 prompt "запит 3"
on sele bar 1 of xx1 do zapros1
on sele bar 2 of xx1 do zapros2
on sele bar 3 of xx1 do zapros3
define popup xx2 from 4,12 to 12,20
define bar 1 of xx2 prompt "абонент"
define bar 2 of xx2 prompt "плата"
define bar 3 of xx2 prompt "розмова"
define bar 4 of xx2 prompt "зона"
on sele popup xx2 do basa with bar ()
activ menu ats
deactiv menu ats
procedure basa
parameters k
close database
do case
case k = 1
use abon
browse
use
case k = 2
use mts
browse
use
case k = 3
use plata ​​p>
browse
use
case k = 4
use razg
browse
use
case k = 5
use zona
browse
use
endcase
В В В
7. Лістинг ПРОГРАМ. <В
zapros1.prg
close database
use abon
use plata in 2
index on n_t to abon
sele 2
index on n_t to plata ​​p>
sele 1
set rela to n_t into 2
set filter to b.dolg> 100000
brow fields a.fio, b.dolg
set rela to
set filter to
zapros2.pr...