To Use the Visual SQL Query Builder to Build a Query: Example 3
Note: The Visual SQL Data Browser only displays the data. Make edits to the database in the Forms mode.
Note: To edit any of the Where clauses, click the clause in the Where Fields list box. Dynamically change the field, operator, value, and AND/OR clause members as you would normally do when building an SQL statement. Clicking Apply conforms the SQL Select Statement to your changes in the Where Fields dialog. You can also delete the clause by clicking Clear.
- Click Clear All to clear any existing tables.
- In the Select tab page, click Tables or select menu option .
- In the Select Table dialog, double-click Parcel.
- In the Select Table dialog, click Cancel.
-
In the Parcel dialog, double-click the Parcel_no, owner, house_num, str_name fields.
The following displays in the SQL Select Statement text box:
SELECT parcel_no, owner, house_num, str_name FROM parcel
-
Click the Where tab.
The Where tab page opens.
-
In the Available Fields list box, click the parc_value field.
The selected field appears in the Where Fields list box.
- Click >= (greater than or equal to). In the Value text field, type 50000 and press <Enter>.
-
Click And to create the second WHERE clause.
AND displays in the Where Fields list box.
-
Click parc_area in the Available Fields list box, click >= (greater than or equal to), enter 100000 in the Value text field and press <Enter>.
The entered operator and value display in the Where Fields list box.
-
Click Apply to add the clause in the Where Fields list box to the SQL Select Statement text box.
The following displays in the SQL Select Statement text box:
SELECT parcel_no, owner, house_num ,str_name FROM parcel WHERE parc_value >= 50000 AND parc_area >= 100000
The query in the SQL Select Statement text box is complete.
-
Click Execute.
If Execute generates a dialog form.
is turned on in the Visual SQL Query Builder dialog, clickingIf Execute generates a list (containing the same information as in the dialog form) which is displayed in the Visual SQL Data Browser dialog.
is turned on in the Visual SQL Query Builder dialog, clicking