User Guide

Running DBWizard
30
i!-Database Plus and DBWizard
Queries Tab
The Queries tab is where you build and decide how to access the database from NetLinx. On the
left, you will see a set of tabs for Tables and Views. This represents the information contained in the
database.
When you select a table or view, all the fields for it will show up in the "Fields For..." window. For
a given table or view, you can select any or all fields to read or write to the database. In Microsoft
Access, any query entered under the Queries tab will show up in DBWizard under the View tab.
Once you have picked a set of fields, enter a query name in the upper right text box. This name will
be used to identify which set of information you are talking about in the database. Use a meaningful
name here: for instance, if you are reading the name of CD's and their artists, call the query
CDNames or something that makes sense to you.
When you have filled in the name, choose whether you want to read, add, update or delete this
information in the database. If you have chosen a view, only read is allowed. When you choose
read, the Page Size box is enabled. Enter how many records you want to see at one time on your
touch panel here.
Once you have picked your access methods, click Save. When query name is moved to the Queries
box in the bottom right, you are ready to build your next query. You can enter multiple queries for
any table or view in the database if you want to get different information or have the information
sorted in a different way.
For existing queries, you can review the properties with the Properties button. You cannot edit the
information here so if you make a mistake, delete the query using Delete and add it again.
If you want records sorted, choose Sorting and add sorting information to any query.
Sorting
When you press the Sorting button for a query, you will be presented with the Sorting dialog. All
the fields for the query will appear in the left hand list box. To sort by a given field, select the field
and hit the -> key or double click the field. The field will be moved to the Sorted Fields list box.
The Ascending and Descending buttons at the bottom of the Fields list box allow you to determine
if you want the fields sorted in ascending or descending order.
Once a field(s) is in the Sorted Fields list box, you can change the sorting order by selecting the
field and pressing the up or down buttons at the bottom of the list box.
If you make a mistake and do not want to sort a field anymore, select the fields and hit the <- button
or double click the field. The field will then be moved to the "Fields" list box.
When you are finished, click OK. If you do not want to save your sorting changes, click Cancel.