.
. . , , . Delphi , . , , , . , . .[5]
Delphi DBTable ADOTable, DBQuery ADOQuery, DataAccess, DataControl, DecisionQuery StoredProc.
StoredProc , UpDateSQL . DecisionQuery . , , Table Query, .[5]
DataSet.
DataSet, ( ). .
DataSet ADO. , .
ADO, , , ADO. , ( ) , SQL, , . .[5]
Table Query.
Table Query ADODataSet DataSet. , .
DOTbl Delphi , OLE DB. . ADO, .
. ADO , SQL.
Table , . , Table , dBase Paradox. Query. Table TableName, .
|
|
|
TableName . . , , TableName.
ADOQuery SQL ADO. .
Query , SQL- . Query. SQL. , . Query Next Insert, . Query Table. Table. Query . , , SQL Strings. SQL . SQL SQL-. SQL- , .[5]
2.3
Delphi.
DataControls . , . , .[5]
, . , , Edit Image.
. DBGrid DBCtrlGrid, . Standard Additional , , , DataSource Datafield. , - , . , Edit , .
, , . .
|
|
|
. Edit . () , , , Post .[5]
.
, , Control. , , , . Control , . : .
, . , , , , .
, Edit, DBEdit, Memo DBMemo . , , .
GraphiControl, Control. . .
.
. .
Name , . , , , . .
Aling , . , , - .
Caption . , .
Color . . , .
. :
- ;
- ;
- ;
- ;
- drag-and-drop.
, , , , .
.
. , , , . , . .
|
|
|
. , , , . Table Query .[5]
:
- ;
- ;
- ;
- ;
- ;
- .
, .
. , , , , . . , , :
- ;
- ;
- .
Insert . :
- ;
- ;
- .
Delete, . , , , . , Delphi .
.
. . . . .[5]
, . Table Query . Table . . , , .
, . ixDescending , , . ixDescending , . , , IndexName.
. , , .
. , , CheckBrowseMode. :
|
|
|
- First - ;
- Next - ;
- Last - ;
- Prior - .
, .
. , , . , .
.
- , . , . , . Delphi :
- ;
- .
, Table , Query , SQL-, SQL. SQL-, . SQL- , , .
, , .
, , . , , .
, :
- ;
- ;
- ;
- ;
- ;
- .
, . , - , . . - , . <,>,=,<=,>=,<>. +, -,* /. AND, OR NOT. .
Table : Filter OnFilterRecord.
Query : SQL-, OnFilterRecord, .
, , .. > AND < . Table.
. , , - , . , IndexName IndexFieldName. , .
ApplyRange CancelRange. , - . , , . , , , - .
|
|
|
.
, , . , . , .
, . , , .
Locate Lookup, . Locate . , . , True, False. , . , . Lookup , , , Locate, , . , Lookup .
Table , . , . , , , , . , . , , , , .[5]
SQL
SQL . - , , , .
. , . , , , , - , , , . , , . , , SQL (, , ) .[2]
SQL.
SQL , . , SQL :
- (Data Manipulation Language, DML)
- (Data Definition Language, DDL)
- (Data Control Language, DCL).
, . .
, , . 4 :
SELECT ()
INSERT ()
UPDATE ()
DELETE()
- , , ( ), . :
CREATE DATABASE ( )
CREATE TABLE ( )
CREATE VIEW ( )
CREATE INDEX ( )
CREATE TRIGGER ( )
CREATE PROCEDURE ( )
ALTER DATABASE ( )
ALTER TABLE ( )
ALTER VIEW ( )
ALTER INDEX ( )
ALTER TRIGGER ( )
ALTER PROCEDURE ( )
DROP DATABASE ( )
DROP TABLE ( )
DROP VIEW ( )
DROP INDEX ( )
DROP TRIGGER ( )
DROP PROCEDURE ( )
. . :
GRANT ( )
REVOKE ( )
SQL:
- SQL
- SQL.
SQL ( WISQL DBD), SQL, .
SQL , , set- record- .
SELECT. () .
AND, OR, NOT, : (AND, ), (OR, ), (NOT, ). AND. . AND , , , AND, .
OR , , , OR, . NOT , , , , . : NOT, - AND - OR. .
(ORDER BY)
() ORDER BY SQL-. :
ORDER BY < > [ASC | DESC]
:
- ;
- .
ASC DESC. - - (ASC). DESC, .[2]
