Databases Reference
In-Depth Information
The part between the comment characters (
/*
*/
) will be expanded later, and the
tags will be removed. We label this query as a bookmark named
find author by
name
(before executing it) and then click on
Go
. The first execution of the query just
stores the bookmark while retrieving all topic by all the authors, as this time we
haven't passed a parameter to the query.
In this example, we have two conditions in the
WHERE
clause, of which one contains
the special syntax. If our only criterion in the
WHERE
clause needs a parameter, we can
use a syntax such as
/* WHERE author_id = [VARIABLE] */
.
Passing the parameter value
To test the bookmark, we recall it as usual and enter a value in the
Variable
dialog.
When we click on
Go
, we see the expanded query, and the author Smith's topics.
Search WWH ::
Custom Search