Data Sources

Data Sources

The text, barcode, picture, price and list objects on the label need to get their data from somewhere. In TICKET 2000 you have a choice of 10 different data sources !! You can change the active data source for any object at any time.

Text Link
Simply specify the text for the object so it wont change. Or you can name another object using [ ] brackets to show the text from that object or do calculation eg:

A price object's text link could be: [RawPrice] * 1.2

So the price object will always show a value of 120% of what ever the raw price is ... ! There is a whole range of commands you can enter to format text, like a mini programming language.

_PadLeft( _TrimSpaces( [Code] ), 0, 8)

This will clean spaces from a code number and pad the final number to 8 characters.. Simple ?

Sequence
You can specify a start, end and increment value. The seqence format can be decimal, hex, octal or even alphanumeric:

Serial Number
Like a sequence but the last number is remember and global to all labels. TICKET 2000 will make sure the same number is not printed twice, even on different labels that use the same serial number.

Date and Time
There is an extensive collection of date and time formats. The date or time can be calculated, asked for, or got from a database. See date and time formats

Global Variable
Include common text and data on labels and be able to change them without editing the labels directly. See variables.

Prompted Question
Asks the user at print time for some data. The question to ask and the expected format of the data can be specified.

Prompted List
Asks the user at print time for some data by displaying a list of options. The question to ask and the list of alternatives can be specified.

Database
Read data directly from Microsoft Access, dBase, Excel, Text, Paradox and other databases. User MS Access Queries to filter data. The query parameter values can be set by TICKET based on user inputs, eg: TICKET can ask for a product code, this code is then used by Access to return the correct product records from the database.

Label Information
Include various information about the label on the printed labels, eg: file name, date of printing, user name, media name, output printer etc.

Console Mode
The various console modes can set data on the label by specifying Console Mode data sources for any objects. For example: To print the current weigh scale weight, you would select "Scale weight" for a text object - its that simple.