: , , .
:
1. . 1- sotrudniki. 2 , Cross-Tab Wizard. 3- , (..7.1):
.7.1. - .
Query . .7.2:
.7.2. .
2. . 1- sotrudniki dolgnosty. 2- Data Series Dolg_id, Axes Sotr_id, , Numeric. 3- . Form - Query .
.7.3. .
3. , 1 2 (..7.4) :
7.1. .
&& -
DO 'd:\militsina\query\SOTR_MAIL_BIRTH_BLANK.qpr'
&& -
DO FORM 'd:\militsina\forms\SOTRUDNIKI_PO_DOLGNOSTYAM'
.7.4. .
4. . 1- sotrudniki ( ). 2- dolg_id. 3- banded - 4- . 5- dolg_id sort_id. Reports. (..7.5):
.7.5. , .
5. . course_data.dbc USE < >, BROWSE, (..7.6). :
) 147
) (, , .)
) : , , , ; , , , .
.7.6. course_data.dbc.
|
|
|
8.
: SQL .
: SQL-, ( 4 ).
1. :
)
)
) (BETWEEN)
) ([NOT]IN)
) (LIKE/ NOT LIKE)
2. :
)
)
)
) ,
3. :
) ( , ..);
) ;
) ;
) ;
)
4. :
)
5. :
) ;
) IN
6. ANY ALL
7.
8.
:
1. 20 Label 2 CommandGroup - 10 (..8.1). OptionGroup, . , SQL- (. 8.1-8.20).
.8.1. .
8.1. 1.
IF thisform.optiongroup1.option1.Value = 1
SELECT film_id, fname, price;
from films;
where price > 220;
ELSE
SELECT film_id, fname, price;
from films;
where price < 220;
ENDIF
8.2. 2.
SELECT film_id, fname, price;
from films;
where country_pr = "";
8.3. 3.
SELECT film_id, fname, price, country_pr;
from films;
where (country_pr like '') AND (price > 220);
8.4. 4.
SELECT film_id, fname, price;
from films;
where price between 220 AND 240;
8.5. 5.
SELECT firstname, midname, lastname, birth_date;
FROM clients;
WHERE ALLTRIM(midname) in ('','');
8.6. 6.
SELECT emp_id, firstname, midname, lastname;
FROM workers;
WHERE firstname like '%';
8.7. 7.
SELECT login, password;
FROM access_table;
ORDER BY login DESC;
8.8. 8.
SELECT film_id, fname, price, genre_id;
FROM films;
ORDER BY genre_id ASC, price DESC;
8.9. 9.
SELECT cl_id, firstname + midname + lastname as FIO, birth_date;
FROM clients;
8.10. 10.
select firstname, midname, lastname;
from workers;
where firstname like '%';
|
|
|
union (select firstname, midname, lastname;
from clients;
where firstname like '%')
8.11. 11.
SELECT AVG(price) as AVGprice;
FROM films;
8.12. 12.
SELECT COUNT(*) as ClientsRowQuantity;
FROM clients;
8.13. 13.
SELECT MAX(price) as MAXprice;
FROM films;
8.14. 14.
SELECT MIN(price) as MINprice;
FROM films;
8.15. 15.
SELECT SUM(all price) as SUMprice;
FROM films;
8.16. 16.
SELECT A.pos_id, COUNT(A.emp_id) as QuantityOfWorkes;
FROM workers A;
GROUP BY A.pos_id;
HAVING A.pos_id = 8;
8.17. 17.
SELECT emp_id, firstname, midname, lastname, pos_id;
FROM workers;
WHERE pos_id = (select pos_id;
FROM positions;
WHERE ALLTRIM(position) = '');
8.18. 18.
SELECT genre as GenreFromUSA;
FROM genres;
WHERE genre_id in (SELECT distinct genre_id;
FROM films;
WHERE country_pr like '');
8.19. 19.
SELECT film_id, fname, price;
FROM films;
WHERE price > any (select price;
FROM films;
WHERE country_pr = '');
8.20. 20.
SELECT film_id, fname, a.genre_id, genre;
FROM films a, genres b;
WHERE a.genre_id = b.genre_id;
, , , , , , , , , SQL-. .
:
1. FoxPro Tutorial http://www.yaldex.com/fox_pro_tutorial
2. Fox Pro http://www.firststeps.ru/foxpro/helpfox/helpfox1.html
3. FoxPro Club http://forum.foxclub.ru
4. .., .. Visual FoxPro 9.0. .: . BHV, 2007. http://www.foxclub.ru/vfpbook/
5. http://li.romab.ru/t_pers_db_4.html
6. Visual Foxpro: http://programming-lang.com/html/foxpro_7/index.html
