QuickLabel PowerForms - Manual (Page 45)

- 45 -
Use Data from Database
1. Select the command Database Access in the Data menu.
2. Click on the Wizard button and follow on-screen instructions.
The database table will be defined on the label.
Database fields will be linked to the specified objects.
Once the database is available in the application, its fields can be used with any form object.
It is possible to use variables in SQL as parameters. The parameters in SQL are preceded by a sem-
icolon (:param_name). Variables used as parameters must have a default value that corresponds to
SQL (a variable used as a parameter in place of the Date Field must have a default value that cor-
responds to a date). DO NOT change the default values of variables used in SQL after defining
SQL. It is however possible, to connect those variables to an EditBox, creating a form that knows
how to filter data.
Use Distributed Printing
The application provides additional printing method. Apart from the regular printing to the local or
network-connected printers it is possible to enable true network printing. In this mode the application
does not connect to the print engine directly to print the labels but creates a batch command .JOB
file, containing necessary commands to describe the current print operation.
The .JOB file can then be either dropped on a specified network folder or sent to the server appli-
cation over TCP/IP network protocol.