, , ; , . , , .
:
- LOCK [ TABLE ] IN
::- { [ ROW | ACCESS ] { SHARE | EXCLUSIVE } | SHARE ROW EXCLUSIVE } MODE
- LOCK [ TABLE ]
(ACCESS EXCLUSIVE)
:
- ACCESS SHARE MODE. SELECT , . ALTER TABLE, DROP TABLE VACUUM. ACCESS EXCLUSIVE MODE.
- ROW SHARE MODE. SELECT, FOR UPDATE FOR SHARE. ALTER TABLE, DROP TABLE VACUUM. EXCLUSIVE MODE ACCESS EXCLUSIVE MODE.
- ROW EXCLUSIVE MODE. UPDATE, INSERT DELETE. ALTER TABLE, DROP TABLE CREATE INDEX. SHARE MODE, SHARE ROW EXCLUSIVE MODE, EXCLUSIVE MODE ACCESS EXCLUSIVE MODE.
- SHARE UPDATE EXCLUSIVE MODE. VACUUM ( FULL), ANALYZE CREATE INDEX CONCURRENTLY.
- SHARE MODE. CREATE INDEX ( CONCURRENTLY). INSERT, UPDATE, DELETE, ALTER TABLE, DROP TABLE VACUUM. ROW EXCLUSIVE MODE, SHARE ROW EXCLUSIVE MODE, EXCLUSIVE MODE ACCESS EXCLUSIVE MODE.
- SHARE ROW EXCLUSIVE MOOE. , EXCLUSIVE MODE, ROW SHARE MODE.
- EXCLUSIVE MODE. INSERT, UPDATE, DELETE, CREATE INDEX, ALTER TABLE, DROP TABLE VACUUM, SELECT FOR UPDATE. ROW SHARE MODE, ROW EXCLUSIVE MODE, SHARE MODE, SHARE ROW EXCLUSIVE MODE ACCESS EXCLUSIVE MODE.
- ACCESS EXCLUSIVE MODE. ALTER TABLE, DROP TABLE VACUUM. .
?
Vi&ual FoxPro : . , . -, , .
|
|
|
, , . , , - . , .
Visual FoxPro . FoxPro (. 20.1).
20.1. ,
| ALTER TABLE | |
| APPEND | |
| APPEND BLANK | |
| APPEND FROM | |
| APPEND FROM ARRAY | |
| APPEND MEMO | |
| BLANK | |
| BROWSE | |
| CHANGE | |
| DELETE | |
| DELETE NEXT 1 | |
| DELETE <n> | 1, |
| DELETE RECORD <n> | |
| DELETE SQL | |
| EDIT | |
| GATHER | |
| INSERT | |
| INSERT SQL | |
| MODIFY MEMO | , |
| READ | |
| RECALL | |
| RECALL NEXT 1 | |
| RECALL RECORD <n> | |
| RECALL <n> | 1, |
| REPLACE | |
| REPLACE NEXT 1 | |
| REPLACE RECORD <n> | |
| SHOW GETS | |
| TABLEUPDATEO | |
| UPDATE | |
| UPDATE SQL |
