MACROMEDIA COLDFUSION STUDIO 4.5-USING COLDFUSION..., Руководство пользователя

Страница: 65 / 236

Accessing Data Sources 65
The SQL Builder is divided into four sections:
•
Toolbar — Contains icons for SQL keywords and commands.
•
Table pane — Provides a view of the tables in your query and allows you to
create joins between tables.
•
Properties pane — Allows you to set the properties of the query such as the
columns that are being selected or the columns that are being updated.
•
SQL pane — Shows you the SQL statement as it is built.
Writing SQL statements
SQL Builder opens a SELECT statement by default, since this is the most common type
of query. If you have not chosen a table, you will be asked to select one.
SQL Builder supports four types of SQL statements:
•
Select
•
Insert
•
Update
•
Delete
The SQL pane does not support reverse editing, so any changes you make in this pane
will not be made to the query in the Properties pane or the Table pane.