User Guide

136 Chapter 8 Accessing Data Sources
Testing and editing a query
You can refine SQL statements after constructing them.
Before inserting a query into an application, we recommend that you test it in SQL
Builder. The following procedure explains how to run a query for testing.
Caution
Only test SELECT statements. When you click Run Query, the SQL statement is
processed. If you run an INSERT, UPDATE, or DELETE statement, the changes that
you coded in the SQL statement are made in the data source.
To test a query in SQL Builder:
1Click Run Query.
2 HomeSite+ for Dreamweaver MX prompts you to enter values for the variables in
the query.
If you save a query, you can edit it later. However, pages containing the query are not
automatically updated. To make the changes take effect, you must reinsert the query
into the pages.
To edit a query:
1 Open the query folder for the data source that you want to use.
2 Double-click a query.
3 Make changes in the Table pane and the Properties pane.
4 Save the updated query.
Note
HomeSite+ for Dreamweaver MX does not update the Properties and Table panes
when you make changes in the SQL pane. If you write a query in the SQL pane and
save it, the Properties and Table panes show no changes. But the SQL pane displays
the SQL generated from changes made in the Properties and Table panes.