The individual DDE commands are described in the following with their syntax and function.
General Syntax Rules
1. The functions SQLExec, SQLCommand, SQLQuery, SQLModifyLink, and SQLActualizeLink can be called without the parameters <DSN>, <User>, and <Password>. If QueryPlus is started and connected to a database, the particular function will be executed on this database. If QueryPlus is neither started nor connected to a database, either the first direct connect is performed, if possible (see Section Connecting to the Database), or the connect window appears where you must enter all the specifications that are required for a connect to the database before the function is executed.
If the parameters <DSN>, <User>, and <Password> have been specified, they are used for a new connect, regardless of whether QueryPlus is already started or connected to a database. After this connect, the old database connection will no longer be available.
2. If the parameter for the name of the corresponding object is specified for the functions SQLCommand, SQLQuery, SQLModifyLink, SQLActualizeLink, then the owner of the object must be specified as well. Otherwise, QueryPlus assumes that the object is your property. To specify the owner, enter the owner as object namefollowed by a tabulator character (ASCII 9) and the actual object name. Owner name and object name are case-sensitive.
General Rules
1. Parameters are always passed as character strings.
2. If more parameters are to be passed, they must be separated from each other by a comma.
3. Except for the actual parameters, blanks must not occur in the parameter list, i.e., between the opening and closing parentheses.
4. The commands SQLExec, SQLCommand, SQLQuery, and SQLActualizeLink only provide data. To transfer this data from QueryPlus to your application, use the commands SQLFetch or SQLFetchLink.
See also: