This page refers to Labeljoy 5, which is not the latest release!
Please upgrade to Labeljoy 6 to get the latest version of the software with all its amazing features, or go to Labeljoy 6 user guide if you already own it.
loading data from a professional database
Labeljoy enables you to connect to a
professional database system
and load data to be displayed on labels.
The supported database systems are:
- MySql
- Oracle
- SQL Server
In the Group settings
dialog box (in the Data source
tab), depending on the type of database selected, the appropriate controls will be displayed to enable you to enter the required parameters to connect to selected database.
Fill the required fields and then click Load schema
to load the list of available tables
from the selected database.
Note:
You can also use the link data source wizard to connect to a data source.
Once the table list is loaded, you can select
the one containing the data you want
to display on the labels.
Alternatively, you can select the last item SQL
and enter a SQL query
to custom-define the data to be loaded.
Note:
On the web, many sites offer resources that can help you learn and write basic SQL queries. Here's a few helpful links:
www.sql-tutorial.net/
beginner-sql-tutorial.com/sql.htm
