toolbar. First, above the left buffer is
a Database: drop-down list with the
previously configured database selected.
To the right of that are four buttons:
the first is Execute selection, the sec-
ond is Execute buffer, the third is
Load object, and the last is Repeat last
query. To the right of the last button
is the Preprocessors drop-down. For
this example, I am using the Variable
substitution preprocessor. This can be
seen in the “actor_id > ?” expression
in the SQL statement in the right
buffer. (As a side note, notice the SQL
syntax highlighting prompted by the
use of the *.sql extension.) To continue,
I have selected the statement I want
to run and then clicked the Execute
selection button. Because I have vari-
able substitution in force, an input
box was presented (not shown) for me
to enter the value for actor_id, in this
case 35. The result is presented in a
separate window. From the result set,
it is possible to save the data as CSV or
tab format or as INSERT statements.
You also can show/hide columns.
Additionally, it’s possible to run multi-
ple statements at once (Figure 6). This
is a somewhat contrived example, but
