AMT Datasouth Fastmark M1 Uživatelská příručka Strana 347
- Strana / 532
- Tabulka s obsahem
- ŘEŠENÍ PROBLÉMŮ
- KNIHY
Hodnocené. / 5. Na základě hodnocení zákazníků
Creating a Query
Figure 11.2: Using the Custom Where Clause
The database table used for this example is called Lesson2.database and it has a label with a database
key field attached to the STOCKNUM column in the database.The following table displays the operators
that could be used in the query and what they mean.
Operat
or
Comparison
= Exactly Equal
LIKE SQL LIKE
<> != # Not equal
> More than
>=
More than or equal
to
< Less than
<=
Less than or equal
to
Loftware LabelManager Version 10.1.1 User's Guide
347
- Loftware Label Manager 1
- Contents 2
- The Loftware Label Manager 7
- Loftware Documentation 7
- Contact Loftware 8
- Technical Support 9
- Checking License Information 10
- System Requirements 12
- Connecting Devices 13
- Device Connection Types 13
- When to use 14
- Web User Connection 16
- Device Connection Summary 17
- Device Configuration 17
- Available Ports 19
- Flow Control 20
- Edit Menu 22
- Right-Click Menu 23
- Device Options 24
- Advanced Settings 24
- Configuring Device Connection 26
- COM Port Settings Section 27
- Advanced Settings Section 27
- LPS Subsystem Logging Section 27
- Reassign a Device Number 28
- Reassign a Device 29
- Configuring RFID Devices 30
- About Printer Family Drivers 31
- ZPL II Family Driver 32
- EPL2 Family Driver 32
- DPL Family Driver 32
- Using the New Media Wizard 34
- Model field 34
- Shared Network Printing 39
- Device Status 39
- Query Status Request 40
- Parallel 41
- Spooling 41
- The Loftware Print Server 43
- Configure Detailed Status 44
- Detailed Status Section 45
- Status Types Section 45
- Behavior Section 45
- About Device Families 49
- Test Printing 49
- To merge the Label Format 50
- Network Printing 51
- Sharing a Local Printer 55
- Sharing a Network Device 56
- Creating a New Label 58
- The Menu Bar 61
- The Positioning Toolbar 65
- Language Options 67
- About Properties 68
- Device Tool Defaults 69
- The Properties Box 70
- Non-Printing Fields 75
- Demand-Print Form 75
- Properties Box Options 77
- Example 1: The Barcode Field 81
- Label Setup Tab 84
- Label Properties Tab 85
- Label Properties Section 86
- Page Layout Tab 87
- Advanced Tab 88
- Legacy Settings Section 89
- Printers and Labels 90
- Page Layouts 90
- On-Screen Label Presentation 91
- Orientation Options 92
- Orientation Example 93
- Using Label Comments 94
- Require Label Comments 95
- Enable Optional Comments 95
- Enter Label Comments 95
- Test-Printing Labels 96
- To test-print a label 97
- Error and Warning Messages 97
- On-Demand Print 98
- Designing a Label 100
- Text Fields 101
- Moving Fields 102
- Creating Text Fields 102
- Designing Labels 104
- Copying a Variable Text Field 105
- Creating the Zip Code Field 107
- Creating the Country Field 107
- Creating the State Field 107
- Creating Barcode Fields 108
- The Finishing Touches 109
- Saving a Label File 110
- Customizing Labels 113
- Select Multiple Fields 114
- Align the Two Fields 114
- Facts about Fonts 115
- Dot fonts 116
- TrueType Fonts 116
- Hybrid fonts 116
- Flexible fonts 117
- Fixed Text Properties 118
- Edit Fixed Text 119
- Text Properties 120
- Interline Spacing 121
- Max # Lines 122
- Paragraph Properties 122
- Images and Graphics 123
- Supported Image Types 124
- Save Fixed Images in Label 124
- Image Properties 125
- Filler Image 128
- Image Size Rule 128
- Dither Method 129
- Lines and Boxes 130
- Box Properties 131
- Creating a Line or a Box 131
- Barcode Properties 132
- Other Editing Methods 133
- Modifying Fields 134
- Field List Creation 135
- For Example 136
- Pass Through Fields 138
- Supplying Data 139
- Supported Drivers 139
- Creating a Pass Through Field 139
- Audit Files 140
- Configuring Global Auditing 141
- Global Audit Options 143
- Date and Time Format Section 144
- Label Name Path Section 145
- Create New File Section 145
- File Naming Section 145
- Delimiter Section 145
- Legacy Auditing 146
- Label Versioning 148
- Prerequisites 149
- Open a Previous Version 149
- Promote a Versioned Label 150
- Promote a Label from Design 151
- Setting up RFID Labels 153
- What is the Tag Type? 154
- HF and UHF RFID 155
- RFID Standards 157
- DoD RFID Requirements 158
- Loftware RFID Concepts 159
- Loftware RFID Requirements 159
- Select a Template Type 161
- Select an RFID Target Device 161
- Set Field and Media Options 162
- New Media Wizard Summary 162
- (F5), a warning is displayed 163
- RFID Field Properties 165
- Data Sources for RFID Fields 167
- Data Source 168
- Overflow 170
- AFI and DSFID 170
- EPC Configuration 171
- DoD Configuration 172
- URI Configuration 173
- DoD Encoding Type 174
- Example 1 - DoD-96 175
- EPC Encoding Types 176
- Example 2 - 96-bit GID 177
- Designing the New Label 179
- Example 3 - 96 Bit SGTIN 181
- Example 4 - 64 Bit SGTIN 184
- Related Information 187
- Example 5 - 96 bit SSCC 189
- Example 6 - 64 bit SSCC Label 190
- Example 7 - GIAI-96 Alt 194
- Supply Data Directly 196
- Scenario 1 (Decode) 197
- Printing RFID Smart Labels 199
- Internationalizing Printing 201
- Definitions 202
- Hierarchy Example 205
- Single Byte Fonts 206
- Input Prompts in LLM ODP 209
- On Demand Print sections 210
- Fran\ais 213
- Reference Tables 215
- Printing Vertical Text 216
- Language Properties Wizard 217
- Font Language Selection 218
- Font Category Selection 219
- Vertical Fonts 225
- Reset Font or Category 228
- Change Language Properties 228
- Native Font Support 229
- Data Sources 232
- Database File Data Source 233
- Method 1 – ODBC Linked Label 234
- To use DELINKFILESRC 235
- Troubleshooting Font Fields 236
- Using Templates and Wizards 239
- What is a Template? 239
- Creating Your Own Template 240
- Barcode Wizards 241
- Changing the Formula 248
- GM Barcode Wizard 249
- Specifications 250
- Advanced Information 257
- Data Fields 258
- GM - Additional Components 259
- UPN Healthcare Wizard 260
- Configuring Data Sources 271
- Accessing a Data Source 272
- About Force Max # Chars 273
- Force Max # Chars Settings 274
- Keyboard Data Source 275
- Update Method and Clear Value 276
- Custom Mask Examples 277
- Date and Time Data Source 278
- Single-Digit Date Formats 279
- Add and Delete Buttons 280
- Calculate Expiration Date 280
- File Data Source 281
- Fixed Data Source 281
- Formula Data Source 281
- Creating a Formula 282
- Formula Examples 283
- Mathematical Operators 283
- String Functions 284
- Special Functions 286
- Other Formula Examples 288
- Creating HIBC Formulas 289
- Extended Mode vs. Native Mode 290
- When the Number Wraps 290
- Serial Number Data Source 292
- Creating a Serial Number File 293
- Script Data Source 294
- A script can be used to 295
- Accessing a Label Field 296
- Field Properties 296
- Font Properties 298
- ASCII Characters in Scripts 300
- Double click on the field 301
- Verify a Script 302
- Clear a Script 302
- Find a Script on the Label 302
- ISBT 128 Barcode Label 303
- Database Data Source 304
- Using Multiple Databases 305
- Fixed-Image Data Source 306
- Database-Key 307
- Database-Data 308
- Database-File Data Source 310
- Database-Serial Number 310
- Printing On Demand 313
- On-Demand Printing 314
- Entering Data 315
- Entering RFID Data 315
- Printing with On-Demand Print 316
- On-Demand Print Form 319
- International Printing 320
- West Chesterfield, NH 03466 324
- Label Design 325
- On-Demand Print Options 326
- Customize 329
- Using Page Layouts 331
- Where Page Layouts are Stored 333
- Managing Page Layouts 334
- Modifying Page Layouts 336
- Printing Using Page Layout 338
- Current Label 340
- End of Job Action 340
- Layouts and Pages 341
- Range Printing Example 343
- Creating a Query 344
- Range Section 345
- Ordering Section 346
- Advanced Section 346
- Saving a Query 348
- Opening an Existing Query 348
- Range Print Audit Files 349
- Working with ODBC 353
- Examples of Data Sources 353
- ODBC Drivers Tab 356
- Tracing Tab 357
- Working with Data Sources 358
- Deleting a Data Source 359
- Data Source Conversion 359
- Barcode Symbology 361
- Unique Barcode Properties 362
- Barcode Symbology Terminology 362
- Character 363
- Aztec Code Properties 365
- Building Aztec Code Barcodes 366
- Code 128 Properties 368
- GS1 Barcode 370
- DataMatrix Properties 371
- EAN 8 and EAN 13 Properties 372
- Interleaved 2-of-5 Properties 374
- PDF 417 Properties 376
- QR Code Properties 378
- Requirements 379
- Building QR Code Barcodes 380
- 7. Select a Symbol Size 381
- TLC39 Properties 382
- GS1 Generic Properties 383
- GS1 SSCC Properties 384
- UPS MaxiCode Properties 386
- MaxiCode Compression 388
- Figure 13.3: MaxiCode Formula 390
- USPS Intelligent Mail® 393
- Property Description Values 394
- Avery Dennison Printers 396
- Avery Dennison Options 398
- C.Itoh Printers 402
- Citizen Systems Printers 402
- Datamax-O'Neil Printers 403
- Supported Features 405
- Datamax Options 405
- Datamax-O'NeilPrinters 407
- Datamax Error Messages 411
- Eltron Printers 412
- Eltron Options 414
- Eltron Error Messages 418
- EXE Printers 419
- Fox IV Information 420
- Supported Printer Models 421
- Intermec and UBI Printers 422
- UBI Printers 423
- Image Support 425
- Supported Fonts 425
- Properties dialog (F5) 427
- Intermec RFID Options 433
- Font Remap Instructions 435
- Intermec IPL Error Messages 436
- Meto Information 438
- Novexx Printers 438
- Novexx Options 439
- Driver Features 443
- Error Messages and Handling 444
- Paxar (Monarch) MPCL1 Options 444
- Using UPC/EAN Extensions 446
- Printer Status (Serial only) 447
- Paxar (Monarch) MPCL2 Options 449
- Paxar MPCL2: More Information 454
- Paxar Error Messages 455
- PCL5 Information 456
- PCL5 Options 457
- PCL5 Printer Specific Options 458
- PCL5 USB Issues 459
- Printronix Information 460
- Printer Status 461
- Printronix Options 462
- PrintronixInformation 463
- QuickLabel Information 468
- SATO Information 468
- SATO Options 470
- SATO Printer Specific Options 471
- Sample of Supported Fonts 473
- SATO Error Messages 475
- Toshiba TEC Printers 476
- Connections 477
- TEC Options 477
- TEC Printer Specific Options 480
- Number of variable fields 483
- TEC Error Information 484
- Windows Printers 485
- Validation 486
- Windows Printer Options 487
- Zebra Printers 488
- Zebra (and ZPLII) Options 490
- Real Time Clock Section 496
- Zebra RFID Printer Options 497
- Zebra TrueType Font Handling 501
- Tag Configuration 503
- RFID Devices and Tag Types 504
- RFID HF Printers 508
- RFID HF / UHF Printers 509
- References 511
- ASCII Code 39 Reference Table 511
- Code 128 Character Sets 512
- Wedge Reader Conversion Chart 514
- IBM ASCII Chart 515
- IBM ASCII Chart (Extended) 517
- Conversion Log 523
- Testing Converted Labels 523
- Recovering from Import Errors 523
- Viewing Application Logs 525
© 2020, manymanuals.cz. Všechna práva vyhrazena. | 0.110 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentáře k této Příručce