If QueryPlus is to be started for a DDE conversation, QueryPlus must be started with the option /Remote. A DDE conversation can be established with an already started QueryPlus application which has not been started with the /Remote option. For a DDE conversation with QueryPlus, the data transmitted and received is always a character string:
Application name : QUERYPL
Topic : QueryPlus DDE Server
The following DDE query options are provided:
SysItems : produces a list of DDE queries and commands.
SQLStatus : produces the status of a DDE communication.
SQLRetCode : produces the return code of the last database request.
SQLResult : produces general results.
SQLCols : produces the number of columns of a result.
SQLRows : produces the number of rows of a result.
The following DDE query options can also be set by a program that can run with DDE:
SQLWithHeader : specifies whether the result contains column names ("1") or not ("0").
SQLSelectAll : specifies whether the result of a search request is to be selected automatically completely for transfer ("1")
or not ("0").
QueryPlus can be addressed by the following DDE commands:
SQLExec : executes an SQL statement directly.
SQLCommand : starts the SQL Dialog in QueryPlus.
SQLQuery : starts the Query Dialog in QueryPlus.
SQLModifyLink : creates or modifies links.
SQLActualizeLink : actualizes links.
SQLFetch : transfers results.
SQLFetchLink : transfers results of single links.