Command Command (DDE)

Microsoft Query

Show All Show All

Command Command (DDE)

Sends an Open command to Microsoft Query. This command is provided for programs that limit the length of strings used with DDEExecute.

This command is available only on the system channel.

Syntax

Command(opnum, execstring)

opnum Determines the way Microsoft Query receives the commands. Can be one of the following values.

Value Description
1 Initializes the buffer in Microsoft Query with execstring (clearing the buffer if it exists), but doesn't execute the query.
2 Concatenates execstring to the end of the buffer.
3 Concatenates execstring to the end of the buffer and executes the complete command buffer. Because the command buffer is cleared after execution, execstring can't be re-executed.

execstring Segments of an Open command. The entire string must be enclosed in single or double quotation marks.

Microsoft Query supports sending only the Open command using the Command command.

Remarks

This command is provided for Q+E compatibility only. It is recommended that you use the BuildSQL command, if possible, to send long SQL statements.