blob: 9d089e72b90d484d8d09a6d8bbdd3a3fa938b12f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
.pgaw:Help.f.t insert end \
"Visual query designer" {bold} "
PgAccess is using an advanced tool for visual designing of queries. \
For those of you that have used Microsoft Access, it will be very familiar.
When a new query is build, an empty canvas will be presented to you. \
In the bottom of the screen there is the " {} "result" {italic} " zone.
Add new tables on the canvas by selecting them from the drop-down or by entering \
their names in the \"Add table\" entry and then pressing Enter.
After adding the source tables on the canvas you can make links between fields from \
different tables by dragging one field and dropping it on the label of the\
corresponding field in the linked table. Links can be deleted by selecting them\
(the link line will change it's colour) and then press \"Delete\" key.
In order to delete a table from the canvas, select it by mouse clicking on the\
name of the table and then press the \"Delete\" key. The tables can be moved\
on the canvas by dragging them from their name labels. The entire canvas can\
be panned by dragging it from an empty area.
In order to select fields that will be included in the result, drag the desired \
field from the table and drop it in the result zone in the desired column.\
If there is already another field in that column, it will be shifted to the \
right together with all the remaining fields to the right and the new field will \
be inserted in the desired column.
You can also specify a condition for records to be included in the result. Go \
to the result zone and in the \"Criteria\" row enter the condition for the \
selected field." {} "
Example:" {italic} "
> 150
we will presume that we entered the above criteria for a numeric field. Or:
= 'CPU'
for a character field.
If you don't want a field to be included in the result and you dropped it into \
the result area just for adding a selection criteria on it, mouse click on \
the Yes or No label in the \"Return\" row.
In order to sort the results on a field, mouse click on the 'unsorted' label in \
the \"Sort\" row.
If you want to remove a field from the result zone, click on it's name and \
then hit the \"Delete\" key.
Pressing the \"Show SQL\" button will display the SQL command that will be \
build from the current tables and result columns. Clicking on the canvas will \
make it dissapear and the table layout will be displayed again.
Check the query execution by pressing on the \"Execute SQL\" button. If the \
query has been executed without error, a query viewer will be displayed and \
you will be able to see the selected rows. When everything is ok, save the \
query command to the query builder by pressing the \"Save to query builder\" \
button.
"
|
