Bookmarks
This chapter covers one of the linked-tables infrastructure's features: query
bookmarks. Being able to label queries and recall them by label can be a real time
saver. In Chapter 12, we learned about the SQL history feature, which automatically
stores queries (temporarily or permanently).
Bookmarks are queries that are:
Stored permanently
Viewable
Erasable
Related to one database
Recorded only as a consequence of a user's wish
Labeled
Private by default (only available to the user creating them), but
possibly public
A bookmark can also have a variable part, as explained in the Passing a Parameter
Value to a Bookmark section later in this chapter.
There is no bookmark sub-page to manage bookmarks. Instead, the various
actions on bookmarks are available on specific pages such as results pages or query
box pages.
??? ??? ??? ??? ??? ??? ???
Bookmarks
[ 220 ]
Creating a Bookmark after a Successful
Query
Initial bookmark creation is made possible by the Bookmark this SQL-query
button. This button appears only after execution of a query that generates results
(when at least one row is found), so this method for creating bookmarks only stores
SELECT statements. For example, a complex query produced by the multi-table
query generator (as seen in Chapter 13) could be stored as a bookmark in this way,
provided it finds some results.
Pages:
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207