Microsoft Access (DDE, dynamic data exchange), , (볺), (). , Microsoft Access Microsoft Word, 볺, DDE.
, SQL .
ᒺ Microsoft Access, ᒺ. .
DDE 볺 . , -, , -. ϳ , , , .
, , Microsoft Word Windows, Microsoft Access. DDE Microsoft Access DDE DDEInitiate . ϳ Microsoft Word .
DDE 볺 . DDE Microsoft Access :
System ();
( );
( );
( );
SQL Microsoft Access ( SQL).
, DDE , Windows. VB , .
DDE:
¨ DDE
¨ DDEExecute
¨ DDEInitiate
¨ DDEPoke
¨ DDERequest
¨ DDESend
¨ DDETerminate
¨ DDETerminateAll
. DDE (DDE) , .
DDE(, , )
DDE .
, , DDE. , Microsoft Windows, .EXE ( .EXE). , DDE Microsoft Excel "Excel" . | |
, , . . | |
, , . |
|
|
ϳ DDE -볺 DDEExecute. DDE Microsoft Access - :
¨ .
¨ - , Visual Basic ᒺ DoCmd.
¨ OpenDatabase CloseDatabase.
-볺 DDERequest - DDE.
-볺 - DDEPoke. ϳ -볺 DDETerminate DDE DDETerminateAll .
, Word Windows, Microsoft Access DDE, Visual Basic . , .
, :
TableList | |
QueryList | . |
FormList | . |
ReportList | . |
MacroList | . |
ModuleList | . |
:
¨ TABLE ,
¨ QUERY
¨ SQLSQL,
:
¨ ; TABLE
¨ ; QUERY
¨ ; SQL [SQL],
, , SQL. , (C:\Msoffice\Access\Samples\.mdb) ϳ (;). | |
. | |
. | |
SQL | SQL 256 , . SQL , 256 , DDEPoke. |
DDEPoke -볺 - (DDE).
, DDE Microsoft Access Microsoft Excel, DDEPoke Microsoft Access Microsoft Excel.
:
DDEPoke , ,
DDEPoke :
, , DDEInitiate. | |
, , DDEInitiate. | |
, . |
|
|
, . , Microsoft Excel.
. .
, . , .
ᒺ Microsoft Access, ᒺ.
6.3.1. SQL Visual Basi.
Visual Basic SQL DDEPoke, .
intChan1 = DDEInitiate("MSAccess", ";SQL")DDEPoke intChan1, "SQLText", "SELECT *"DDEPoke intChan1, "SQLText", " FROM "DDEPoke intChan1, "SQLText", " WHERE [ ] > 100;"strResponse = DDERequest(intChan1, "NextRow")DDETerminate intChan1
$ 6.3.1.
TABLE , QUERY SQL SQL.
All | , . |
Data | . |
FieldNames | . |
FieldNames;T | , ( ) ( ). |
:
. | |
True/False ( Null ) | |
. | |
(Integer). | |
(Long). | |
(Currency). | |
(Single). | |
(Double) | |
/. | |
, 256 . | |
ANSI , 256 (Text). | |
(ᒺ OLE). | |
( Memo). | |
NextRow | . NextRow . , NextRow . |
PrevRow | . PrevRow , . , PrevRow . |
FirstRow | . |
LastRow | . |
FieldCount | . |
SQLText | SQL, . SQL "SELECT * FROM ;". |
SQLText;n | SQL, , n , n , 256. , , SQL: "SELECT * FROM ;" "SQLText;7", , : "SELECT ""* FROM "";" |
:
¨ Microsoft Access (DDE, dynamic data exchange), , (볺), (). , Microsoft Access Microsoft Word, 볺, DDE.
|
|
¨ ᒺ Microsoft Access, ᒺ.
¨ , -, , -.
¨ ϳ , , , .
¨ DDE Microsoft Access DDE DDEInitiate . ϳ (, Microsoft Word) .
1