QuickLabel Designer Pro - Manual (Page 163)

- 163 -
Note:
If the Database toolbar is not visible, select Toolbars from the View menu, then click Database.
3. Click on the Advanced button next to the Order combo box.
The Table Order dialog box opens.
4. Look at the Available fields section. Select all fields by which you want to sort the rec-
ords.
5. Look at the Selected fields section. Define the order or appearance of the fields.
6. Define the sort order for each field.
When you will print or preview the label the records are first ordered by the first field in
the list, then by the second field, and so on until the last field in the list.
7. Click OK.
Quickly Editing Database
Click the icon in the Database toolbar. The application NiceData will open the currently
selected database.
Note:
NiceData must be installed on your computer.
Read Data from the Database
To read data from the database, create a new connection to the database using either of the two meth-
ods below:
l
Click the "New database wizard" button in the Database toolbar
l
Select Database access from Data menu and clicking on the Wizard button.
Follow the on-screen instructions until the Database Wizard finishes.
For every field in the table, you now have a text object on the label. Each database field is available
as a variable on the label.
If your database type is not available in the Wizard or you want to use different driver (OLE DB pro-
vider) for connection to the database, you will have to use direct database set-up option and not the
Database Wizard.
Using ODBC Databases
To be able to use ODBC databases, you first have to setup your ODBC drivers properly. You can do
this in advanced by starting ODBC setup program in Control Panel and modifying Data Source
Names (DSNs) to suit your database file locations. Or you can do the same thing from the labeling
software.
Connection to already defined ODBC data sources can be done using the Database Wizard .
If data source is not defined in the system yet, you will have to use direct connection method and by
pass the Wizard.
1. Open Database Access dialog box, then click the Define button in General tab.
2. In the list of database connection types first find the OLE DB drivers, then ODBC Data
sources.