Show All

Execute a query in the Query Designer (ADP)

When you have finished designing your query, you can run it.

1. If you want to test whether the syntax of the query you are creating is correct, you can verify the query.

   How?

   To avoid problems, you can check the query you have built to ensure its syntax is correct. This option is especially useful when you enter statements in the SQL pane.

   Note   A statement can be valid, and therefore be verified successfully, even if it cannot be represented in the Diagram and Grid panes.

   Note   SQL Verification can detect some, but not all SQL errors. If a query contains an error not detected during SQL verification, the database will detect the error when you run the query.

   1. In the Database window, click Queries under Objects, click the query you want to open, and then click Design on the database window toolbar.
   2. Click Verify SQL Syntax .
2. Click Run .

Notes

• If you are creating a Select query, the results of the query appear in datasheet view.

• If you are creating an Update, Append, Append Values, Delete, or Make-Table query, the Query Designer displays a message indicating how many rows were affected by the query.

• To stop a query that is taking too long to finish, press CTRL+BREAK.