QueryNow Command (DDE)

Microsoft Query

Show All Show All

QueryNow Command (DDE)

Executes the active query for the open DDE channel. If you've used the BuildSQL command to build the query, this command executes the SQL statement in the buffer and opens a query window. This command is available on both the system channel and the query channel.

Syntax

QueryNow( )

Example

This example saves an SQL statement from a query and later sends the same statement to re-execute the query.

sql = DDERequest(Chan, "QueryDefinition")
DDEExecute chan, "[BuildSQL(""" & sql & """)]"
DDEExecute chan, "[QueryNow()]"