Testing the SQL statement

There are two ways to test your SQL statement from the SQL Statement Design screen:

Click the Test SQL button.
Right-click the top half of the SQL Statement Design screen and select Test SQL from the right-click menu.

The results of testing the SQL statement depend on the query type:

If you are testing a SELECT query, this displays the SQL statement and up to 10 rows of the query results:

If you are testing an INSERT, UPDATE or DELETE query, GainSeeker prompts you to make sure that you really want to proceed with running this query.

Note: Use caution when testing an INSERT, UPDATE, or DELETE query. If the query can be processed without errors, it will modify the contents of the specified table. One good precaution is to back up the table contents just before testing the query.

If you click Yes at the prompt, the resulting screen displays the SQL statement and the query results:

If this did not return the results you expected, click Close to return to the SQL Statement Design screen and make changes there.

Note: Some data sources, such as Microsoft Access, may produce error messages about invalid column names. In this case, you must edit the SQL Statement before testing it. For more information, see Special note on INSERT statements.

Otherwise, if the results are correct, click Close and then click Save. This returns you to Step 2 of the Database Integration Wizard and automatically pastes the SQL statement into the SQL statement box.

Designing, viewing and testing an SQL statement

Database Integration Wizard: Step 2