To test an SQL query in QueryPad, you need to add your query to the SQL Entry Pane.
The SQL Entry Pane is in the lower part of the window
There are two ways of doing this, either:
- Enter your SQL query manually in the SQL Entry Pane. You can type in your SQL Query, using the Enter key to insert a line break.
Or:
- Copy your SQL Query from another display such as the SQL window for a List. Simply highlight the SQL query, then use the copy option (available in the Edit menu and also by pressing the CTRL and C keys simultaneously) to store a copy of the SQL on your PC’s clipboard. Then select an entry position in the SQL Entry Pane and use the Paste option (or by pressing CTRL and V keys simultaneously) to add the copied SQL query to QueryPad.
When you have added your SQL Query to QueryPad, you can proceed to test it (see Run your Query in QueryPad).