User's Guide Part V. The SQL Anywhere Programming InterfacesWSQL DDE Server is a Windows application which enables you to access and alter data in SQL Anywhere databases using Dynamic Data Exchange (DDE). This means that applications which can use DDE can access data directly, without having to use other database-querying applications such as ISQL. Many applications such as Excel and programming environments such as Visual Basic support the DDE protocol.
WSQL DDE Server can put query results on the clipboard, or return a memory buffer containing the query results. It can also send commands to the database engine, such as COMMIT or UPDATE.
Some applications have a limit on the number of characters which they can send at one time using DDE. For this reason, WSQL DDE Server can build a command or query piece by piece before executing it.
DDE concepts Using WSQL DDE Server Excel and WSQL DDE Server Word and WSQL DDE Server Visual Basic and WSQL DDE Server