Manual mode

Select a dataset from the data window. Select [Query] > [Design Mode] > [Manual] from the menubar or click the [manual icon] on the toolbar. The query window will be switched to the manual mode. Enter your query statement in the query window.

Writing query

Switch to the manual mode and select [Query] tab and enter SQL statement.

Executing query

To execute SQL statement, select [Run] > [Run Query] from the menubar or click the [Run Query] icon on the toolbar or push the <F5> key. If no SQL error, the result will be shown in the [Result] tab.

Dataset fields

If no SQL error, the result dataset fields will be shown.

Note

If SQL statement have comments and that includes user defined parameter, user defined parameter delimiter, and field value of master set, then the SQL will possibly not work.