ADO
Delphi , MS Access, ADO. , , OLE DB Provider. . OLE DB . OLE DB , Microsoft ADO, . , , ADO.[5]
Microsoft ActiveX Data Objects (ADO) . , OLE DB.
ADO OLE DB (. 1). , , ADO, , SQL, , . SQL, ADO, .[5]
, SQL -- . OLE DB , , , .
ADO, ( , , ) , . , , . ADO OLE DB, , . ADO, .
ADO , ADO, ( SQL, . ADO.
, .[5]
ADO , VCL Delphi , ADO. , , OleDB.pas ADODB.pas.
|
|
. ADO.
ADO , Windows, .
ADO.
ADO :
) :
- ADOConnection;
- ADOCommand;
) :
- ADODataSet - ;
- ADOTable - ;
- ADOQuery - SQL;
- ADOStoredProc - .
ADO Delphi, , ADO.
ADOConnection , . ADO ADOCommand. ADOTable, ADOQuery, AOostoredProc.
. Delphi, . ADO . ADO VCL . ADO, ADO. .[10]
ADO.
. , , ConnectionString.
, . , TADOConnection.
, . 2.
, Use Connection String, Use Data Link File. UDL, , .
, Build. , .
Provider OLE DB . , . Connection . Advanced , Mode. . Microsoft Jet 4.0 OLE DB Provider. Connection.
|
|
. Select or enter a database name dbdemos.mdb. Test Connection. , Test connection succeeded. , .
TADOQuery TADOQuery SQL- ADO. . SQL.
Parameters. , , Open Active True. ( INSERT, UPDATE, DELETE CREATE TABLE), ExecSQL. .
RowsAffected , .
TADOTable ADO . , TCustomADODataSet. Connection ConnectionString.
TableName. TableDirect , . , SQL-. True SQL- .
Readonly, , , , . MasterSource TDataSource, Master-Detail.
GetlndexNames , .
TDataSource - . DataSet, . , .
AutoEdit , True, .
Edit . - OnDataChange .
- OnUpdateData , . Post.
- OnStateChange , .
- , , . TDataSet .[10]