Home

LABELVIEW 2014 – Database Manager

1. Database Queries Chapter 4 25 Remove a filter Database Manager must be open to the Filter tab in the Database Query window At least one filter must exist 1 Click the database cursor for the required field 2 Click the Remove row button Fields Fites SOL Query Filter selection Canditiane able Logical Field Operator Value MAME FLUORINE RISKA F And RISKA 2 lt null Modify a filter in SQL Database Manager must be open to the SQL Query tab in the Database Query window At least one filter must exist 1 Select the Modify the query in SQL language option to activate the SQL Query and make manual changes Fields Filters SQL Query Select SQL query Modify the query in SOL language Chapter 4 26 Database Manager User manual 2 Click Query COO The filter can be created directly in SQL without having to use the Filter tab first Choose an existing query in a database Database Manager must be open in the Database Query window 1 Click the Query drop down list 2 Click the required data The selected query can be modified later CHAPTER 9 Printing Print window Database Manager DEAR Fie View Tools Print cai A Database Table Query noe z Database Chemical i 9 CHEMICAL v 000 Queri v Connections A we
2. Page setup Chap 5 31 Preview Chap 5 28 preview Chap 5 28 Print Chap 5 27 print media Chap 5 31 printer Chap 5 29 printer properties Chap 5 32 Printer settings Chap 5 30 Printing Chap 5 27 printing Chap 5 33 R Remove Chap 1 6 Remove filters Chap 4 25 S search tool Chap 3 15 Select Chap 3 14 Chap 4 19 Select records Chap 3 14 Chap 5 30 Select deselect Chap 4 20 software Chap 5 28 Sort Chap 3 17 Sort filters Chap 4 24 SQL Chap 4 25 T table Chap 2 8 Type Chap 2 10 type of content Chap 2 10 y View table Chap 2 10 Index Chapter 6 37 Chapter 6 38 Database Manager User manual Setting the Standard W BAR CODE SOFTWARE L Copyright 2014 Teklynx Newco SAS All rights reserved www teklynx com www teklynx eu
3. Update variable with database 0 0 0 ees 5 33 Merge Database attached to document 5 33 Allow the database to be edited 0 0 cee 5 34 SOP PMNIING ortae sed oe Bese eee ede ae DEDE DE NEEDS eee 5 34 Refresh database VIOW 1 ce eee ees 5 34 Close a doCument lt 54 c 220 dedeeeeied dc56e8 LS Seid 6 Ses 46 e4 Shee 5 34 Chapter GE INdGx 2 ude ies ow es whe Vd es ncn ee SE 6 35 CHAPTER 1 Connecting to Database Files Database Connections window Database Manager Database Connections Connection Name Database Connections Structure Edit Database Database Query Figure 1 Database Connections window The Database Connections window is used to connect the software to the various database files that are to be used Chapter 1 2 Database Manager User Guide Connect the Database Manager module to the database Database Manager must be open in the Database Connections window You can connect the Database Manager module to an existing database or a new one To create a new database to connect to the Database Manager module 1 Go to File gt Create new database 2 Select dBase or Access database from the submenu A Save as dialog box will open allowing you to specify a name and location for the database file and then click Save The new database connection will be displayed in the Database Connections window To connect an existing datab
4. 1 Select the Allow Null check box for the required field Chapter 2 12 Database Manager User manual Allow null yw 2 Click Apply CHAPTER 3 Database Contents Edit Database window _ Database Manager File Yiew Tools Edit Database va Database Table fet EEFI J Connections z fal BO NAME RISKR1 RISKR2 RISKR3 RISKR4 RISKS1 Database Structure 1VAA TRICHL R20 null null null 524 25 R1 R20221722 null null 535 R21 22 R36 38 null null 35 R10 Ri21 22 R34 R43 null R45 null R22 null R11 null R24 25 null R22 null Database Query FLUORINE R7 null Edit Database lt il Rec m a 5 pt Number of records 11 The Edit Database window is used to manage the contents of the database file From this window you can modify or delete data These actions depend on the type of database Excel file records cannot be modified Chapter 3 14 Database Manager User manual Select records according to their content Use the content of a field to find a record Database Manager File View Tools mg Database Database Chemical Connections Database Structure Edit Database m9 Database Query Database Manager must be open in the Edit Database window 1 Click the drop down list button 2 Click the required data 3 Click the data input field 4 Enter the required value in the data input field Edit Databa
5. 2 9 View hide active table s data 0 0 cc es 2 10 Define a key field 1 0 ce eee eens 2 10 Define a field s type of content 2 0 0 eee 2 10 Define a field s maximum size 0 2 0 00 00 ee 2 11 Allow an empty field 0 20 0 0 cc ee eens 2 11 Chapter 3 Database contents 0000 eee eee ees 3 13 Edit Database window 20 0 eee 3 13 Select records according to their content 3 14 Use the content of a field to find a record 3 14 Select all identical records 0 0 ec eee 3 14 Select an identical record 0 0 0c ee 3 15 Find a record according to its row inthe table 3 16 Create a new record aaua naaa a eee 3 16 Duplicate a record 1 0 cc ee ees 3 16 Modify arecord 2 nccneteaskdeeatadewatie butane tree dtaneeaeee ts 3 17 Sort a series of records by alphanumerical order 3 17 Delete a record nuana naa ee eee 3 18 Chapter 4 Database queries 0 0 c eee eee 4 19 ii Database Manager User manual Database Query window 0 keen ne 4 19 Aada OUIGTY e pa e Bs AG ende Per dne Re ET fg ee deem D ne FE od oe eee ert 4 19 Select deselect one or more fieldS 0 0 00 ce ee 4 20 Modify the order of fields selected 0 0 0 0 cece eee eee 4 20 Create a filter using predefined data 4 21 Apply a logical op
6. Remove CHAPTER 2 Database File Structure Database Structure window gt Database Manager File Yiew Tools Database Structure ag Table Database i Chemica y CHEMICAL v Connections Length Allow null g Add table LI sii siits fs sii siiis x si siis OOOO Varchar Varchar Varchar Varchar Varchar Varchar VYarchar VYarchar Varchar Varchar Varchar Delete table View data Apply Cancel The Database Structure window is used to manage the structure of the databasefile From this window you can add modify or delete tables and fields Chapter 2 8 Database Manager User manual Choose a database from the list of connections Database Manager must be open in the Database Structure window 1 Click the Database drop down list 2 Click the required data Database Chemical sl Chemical COFFEE Copy of Chemical FITTINGS Choose a table in a database Database Manager must be open in the Database Structure window 1 Click the Table drop down list 2 Click the required data Table CHEMICAL CHEMICAL LJ Add a table to the active database Database Manager must be open in the Database Structure window 1 Click Add table 2 Enter the name of the new table 3 Click OK Database File Structure Chapter 2 9 Add table Table Name Chemical Duplicate with You can also copy the structure of the table from a table
7. template and printer must be selected The records to be printed must also be selected Printing must have already been launched Click the Stop printing button a Refresh database view Database Manager must be open in the Print window A label template and printer must be selected At least one record must also be selected Click the Refresh database button Close a document Database Manager must be open in the Print window A label template must be selected 1 Click the Documents drop down list 2 Click he data required 3 Click the Close current document button xi Index A Add a query Chap 4 19 automatically Chap 5 31 C Connect Chap 1 1 Create Chap 3 16 D database Chap 2 8 Database Query Chap 4 19 Delete Chap 3 18 Deselect Chap 4 20 document to be printed Chap 5 28 E Edit Database Chap 3 13 empty field Chap 2 11 existing query Chap 4 26 F field s maximum size Chap 2 11 filter Chap 4 21 Find Chap 3 16 Find a record Chap 3 14 H hide Chap 2 10 Hide table Chap 2 10 I identical records Chap 3 14 K key field Chap 2 10 L label design software Chap 5 28 label template Chap 5 28 M manually Chap 5 30 Merge Database Chap 5 33 Modify Chap 3 17 Modify filter Chap 4 25 N new record Chap 3 16 null field Chap 2 11 O options Chap 5 28 Ordered fields Chap 4 20 Chapter 6 36 Database Manager User manual P
8. Click the Add row button Fields Fiter SQL Quer Select filte Conditions table Logical Operator 2 Click in the Field field 3 Click the drop down list button 4 Click the required data Chapter 4 22 Database Manager User manual NAME 5 Click in the Operator field 6 Click the drop down list button 7 Click the required value Operator gone w Database Queries Chapter 4 23 Table 1 Description of operator functions Operator Lookup Equal to lt gt Different from gt Greater than gt Greater than or equal to lt Less than Less than or equal to NOT IN LIKE NOT LIKE BETWEEN NOT BETWEEN 8 Click in the Value field 9 Enter the required value Value FLUORINE 10 Click Query Chapter 4 24 Database Manager User manual Apply a logical operator to several filters Database Manager must be open to the Filter tab in the Database Query window Several filters must exist 1 Click in the Logical field 2 Click the drop down list button 3 Click the required data 4 Click Query to apply and view the changes Sort the list of filters Database Manager must be open to the Filter tab in the Database Query window Several filters must exist 1 Click the database cursor for the required field 2 Click the Up or Down arrow to reach the required data Conditions T able Operator MAME FLUORINE Ur RISKR1 IN F RISKRZ
9. TEKLYNX LABELVIEW teen EEan a aratan iy h Tah inti J D A T A B A S E M A N A G E R Database Manager User Guide DMAN US 01 11 13 The information in this manual is not binding and may be modified without prior notice Supply of the software described in this manual is subject to a user license The software may not be used copied or reproduced on any medium whatsoever except in accordance with this license No portion of this manual may be copied reproduced or transmitted by any means whatsoever for purposes other than the personal use of the buyer unless written permission is obtained from Teklynx Newco SAS 2014 Teklynx Newco SAS All rights reserved Table of Contents Chapter 1 Connecting to database files 005 1 1 Database Connections Window 2 00 eee ee ee eee 1 2 Connect the Database Manager module to the database 1 2 Modify the database connection parameters 1 6 Remove aconnection auaa ee eee 1 6 Chapter 2 Database file structure 0 0000 eee eee eee 2 7 Database Structure WINdOW 2 0 ce ee eee 2 7 ie orc ee ee ee a ee ee he 2 7 Choose a database from the list of cConnections 2 8 Choose a table ina database 00ee ene ennen es 2 8 Add a table to the active database 0 0 cee ee 2 8 Delete a table in the active database 0 0 eee eee
10. agging the top of the window Printing Chapter 5 31 Selecting Database Manager must be open in the Print window records automatically 1 Click the drop down list button 2 Click the data required 3 Click the data input field 4 Enter the data required 5 Click the Select all button 6 Click the Verify button Configure the print media Database Manager must be open in the Print window A document must be selected 1 Click on the Page setup button o sxia Chapter 5 32 Database Manager User manual Display the selected printer s properties Database Manager must be open in the Print window 1 Click the Page setup button SEE Settings Define the number of printed pages according to a field 2 Click Settings Database Manager must be open in the Print window and a printer must be selected Records to be printed must also be selected 1 Click the Quantity column drop down list 2 Select the data required 3 Click the selected data s drop down list button 4 Select the required value or enter a whole numeric value Note This option allows a selection of labels to be printed according to numeric values defined in specific fields Different criteria can be set e SERIALQTY Defines the number of times the label series will be printed e LABELCPY Defines the number of times the label selected will be printed e PAGECPY Defines the number of times the page of labels will be printed Pr
11. ase to the Database Manager module 1 Go to File gt Open A File selection dialog box will open allowing you to browse to and select the database of your choice You can only select the following database types Access mdb Excel xls Dbase dbf Note A wizard is available to help you connect the software to the most frequently used databases Choose the format option that matches your database format If the format required is not available do the following Connecting to Database Files Chapter 1 3 1 Click Add 2 Select a database type from the list or Select Others 3 Click Connection Setup Add database connection Advanced mode Connection Setup Connection string Provider Microsoft Jet OLE DB 4 0 Persist Security Info False 4 Click the Provider tab on the dialog box 5 Select the required provider Chapter 1 4 Database Manager User Guide E Data Link Properties Provider Connection Advanced I ad Select the data you want to connect to Fourmieseurs OLE DE OLE OB pour l annuaire Active Directory de Microsoft Provider MediaCatalog0B OLE DB Provider MediaCatalogMergedDB OLE DB Provider MediaCatalogy ebDB OLE DE Provider Microsoft Jet 4 0 OLE OB Provider Microsoft OLE OB Provider For Data Mining Services Microsoft OLE DB Provider for Indexing Service Microsoft OLE DE Provider for Internet Publishing Microsoft OLE DE Provider for ODBC Drivers Microsof
12. erator to several filters 4 24 Sort the liSUortiters s 3 osi 3 5 4 oo ee A ae Bie ee ee anche 4 24 Remove a filer 2 0 teas US Sree ne ted ee ee ee eee se eee eS 4 25 Modify a filter in SQL 2 asp tisk te ei ale el a ae tee 4 25 Choose an existing query ina database 0 0 e eee 4 26 Chapter 5 PrintinG s4c 050twis Minas overs hed ek Gavan hee awa 5 27 NE PrAt WINGOW 2 5 6054 aro date ou ed ABS OU a ODER ER wee eer she 5 27 Display options 222000nu ee ee ees 5 28 Preview the document 0 0 ee ees 5 28 Display the label design software 0 000 cece ee eee 5 28 Select a document to be printed 0 cc ee 5 28 Create a new label template for printing 5 28 Select an existing label template 0 0 0 0002 eae 5 29 Selecta printer ma or eee EA RA ee eee eae 5 29 Configure the selected printer 0 aaa aaae ee 5 29 Select records to be printed 0 0 0 ee 5 30 Selecting records manually 0 0 00 cece eee eens 5 30 Selecting records automatically 0 0 0 00 ee 5 31 Configure the print Media 0 ees 5 31 Display the selected printer s properties 5 32 Define the number of printed pages according to afield 5 32 Launch POM Clete Sin tek aa tice who eon Gols bd ieee kasper alta 5 33 Launch printing manually each time 0 000 eee 5 33
13. ick the search tool s data input field 2 Enter the required data Rec HM 4 E h Create a new record Database Manager must be open in the Edit Database window 1 Click a field in the row marked with an asterisk 2 Enter the required values in the corresponding fields 3 Click Apply Hinuli null null null null null Duplicate a record Database Manager must be open in the Edit Database window 1 Click or double click a row or a series of rows to highlight the selected records 2 Right click to view the context menu 3 Select Duplicate selected record s Modify a record Database Manager must be open in the Edit Database Database Contents Chapter 3 17 window ask MA fet BO MAME RISKR1 RISKR2 RISERS RISKA 4 RISKS 1 1 1 TRICHL R20 null null null gafr 25 HEER TETA Al null null 535 1234 5PEN Rel fae Rab Se null null 535 1 2 DIAMING R10 R217222 R34 A43 59 BENZENE HOS eaea 73 24 25 nul 553 CURE Uy CANAZN ull null 527 _ CYCLOBUTA R11 null null null sg ENDOSULFA R2425 R36 null null 520 ug FENSON R22 R36 null null S24 FLUORINE R7 R26 R39 null 57 79 Ea 1 Click on the data you want to modifiy 2 Enter the required data 3 Click Apply Sort a series of records by alphanumerical order Database Manager must be open in the Edit Database window There must be at least two rec
14. inting Chapter 5 33 Launch printing Launch printing manually each time Database Manager must be open in the Print window A label template and printer must be selected The records to be printed must also be selected Click the Print records button a cue I Database Manager must be open in the Print window A label template and printer must be selected The records to be printed must also be selected 1 Select the Display the print dialog box between each record 2 Click the Print records button Update variable with database Merge Database attached to document Allow the database to be edited Database Manager must be open in the Print window A label template and printer must be selected The records to be printed must also be selected 1 Select the Update variable with database 2 Click the Print records button Database Manager must be open in the Print window A label template and printer must be selected The records to be printed must also be selected 1 Select the Merge Database attached to document 2 Click the Print records button Database Manager must be open in the Print window A label template and printer must be selected The records to be printed must also be selected Chapter 5 34 Stop printing Database Manager User manual 1 Select the Allow the database to be edited 2 Click the Print records button Database Manager must be open in the Print window A label
15. ords in the table 1 Click on the name of the field required LOTNUM LOTNUM LOTNUM F 1011 1999 1030 1001 1001 1026 1999 1002 1025 1003 1002 1024 1007 1004 1023 1005 1011 1007 1003 1009 1011 1005 1004 1002 1002 1001 1030 3933 Chapter 3 18 Database Manager User manual To sort records in descending order click the same field again Delete a record Database Manager must be open in the Edit Database window 1 Click the database cursor for the required field 2 Right click the database cursor for the required field 3 Click Delete Record in the context menu j Delete selected record s 005 galt CHAPTER 4 Database Queries Database Query window gt Database Manager DAR Fie View Tools Database Query ap oes nl ea Uo es Far a La RE nere Database Chemical x EP cHemcaL wA foun Connections Fields Fiters SQL Quer yZ Field selections Addaem Database Structure ANA Unused fields an Ordered fields 7 ooo NAME Z ey RISKR1 RISKR2 RISKR3 l RISKR4 Edit Database RISKS1 RISKS2 RISKS3 RISKS4 LOGOT LOGO2 Database Query L NAME RISKR1 RISKR2 RISKR3 RISKR4 RISKS1 gt 1 11 TRICHL R20 nul null nul 524 25 1 2 3 4 TETRA Rl R20 21 22 null null 35 1 2 3 4 5PEN R21 22 R36 38 null null 35 1 2 DIAMINO R10 R21 22 R34 R43 S BENZENE R45 R11 R23 24 25 null 53 CAPTAFOL R45 R43 n
16. rint window label template for printing Click the Create labels wizard button xi 6 Follow the wizard s instructions Printing Select an existing label template Chapter 5 29 Creating a label in relation to the database allows you to define exactly which elements are required to position each database field Database Manager must be open in the Print window 1 Click the Open an existing document button ollella 2 Select a label file 3 Click OK COS The Field radio buttons in the Label name and Printer name groups of options allow you to choose the label or printer required when label or printer is defined in one of the fields of the active database Select a printer Database Manager must be open in the Print window A label template must be selected 1 Click the Add or remove a printer button dj 2 Select the printer required 3 Click Validate The last printer used is selected by default Configure the selected printer Database Manager must be open in the Print window A label template and printer must be selected Chapter 5 30 Database Manager User manual 1 Click the Printer settings button slej 2 Adjust the required settings 3 Click OK Select records to be printed Selecting Database Manager must be open in the Print window records manually 1 Select the checkboxes next to the records required Note The height of the data display grid can be modified by dr
17. se Table z CHEMICAL a B0 RISKR2 RISKR3 RISKA4 RISKS1 Cancel 1 23 45 PEN _ 1 2DIAMINO CAPTAFOL CYANAZINE ENDOSULFA FLUORINE R7 null null null null null null null R34 R43 R23 24 25 null null null null null null null null null null null R35 null R21722 R10 R45 R45 R22 R11 R24 25 R22 R36 38 R21 22 R11 R43 null null R36 R36 R26 BENZENE CYCLOBUTA FENSON Number of records 11 gt Pi Select all identical Database Manager must be open in the Edit Database records window and at least one record must exist 1 Click the drop down list button 2 Click the required data 3 Click the data input field 4 Enter the required data in the data input field Database Contents Select an identical record Chapter 3 15 5 Click the Select all button You can also specify the filter by clicking on the a 4 Check case button Database Manager must be open in the Edit Database window and at least one record must have been found There must be several identical contents in the Search field To select a record use the search tool click 1 First 2 Previous 3 Next or 4 Following Rec mw af 5 H 1 2 3 4 Chapter 3 16 Database Manager User manual Find a record according to its row in the table Database Manager must be open in the Edit Database window 1 Cl
18. t OLE DE Provider for OLAP Services 6 0 Microsoft OLE OB Provider for Oracle Microsoft OLE DB Provider for Search Microsoft OLE OB Provider for SOL Server Microsoft OLE DE Simple Provider MS DataS hape SOL Native Client 6 Click Next The choice of provider changes according to the system s type of database 7 Click the Browse button 8 Select a file 9 Click Open Connecting to Database Files Chapter 1 5 E Data Link Properties Provider Connection Advanced Specify the following to connect to Access data 1 Select or enter a database name pe 2 Enter information to log on the datbase Blank password Ol Allow saving password Test Connection 10 Click OK 11 Click Next 12 Enter a name for the connection Add database connection Finish Connection Name 4 Chemical Connection string ix Provider Microsoft Jet OLEDB 4 0 Persist Security Info False 13 Click Finish Chapter 1 6 Database Manager User Guide You can repeat this procedure as often as necessary to obtain the required number of connections Modify the database connection parameters Database Manager must be open in the Database Connections window The required connection must be selected 1 Click Edit 2 Make the required changes Remove a connection Database Manager must be open in the Database Connections window The required connection must be selected H Chemical 1 Click
19. that already exists in the selected database To do so 1 Select the Duplicate with option 2 Click the drop down list 3 Click the required data 4 Click OK Add table Table Name Chemical Duplicate with CHEMICAL CHEMICAL Delete a table in the active database Database Manager must be open in the Database Structure window 1 Click the Table drop down list 2 Click the required data Chapter 2 10 Database Manager User manual CHEMICAL E CHEMICAL 3 Click Delete table View hide active table s data Database Manager must be open in the Database Structure window To review the active table s data click View data Define a key field Database Manager must be open in the Database Structure window 1 Select the checkbox next to the required field Dri a d l NA 2 Click Apply Define a field s type of content Database Manager must be open in the Database Structure window 1 Click the required field in the Type column 2 Click the drop down list button 3 Click the required data Database File Structure Chapter 2 11 Varchar Decimal Mema 4 Click Apply Define a field s maximum size Database Manager must be open in the Database Structure window 1 Click the required field in the Length column 2 Enter the required value Length Al 3 Click Apply Allow an empty field Database Manager must be open in the Database Structure window
20. ull null 53 CYANAZINE R22 null null null 22 CYCLOBUTA R11 null null null 59 ENDOSULFA R24 25 R36 null nul 28 FENSON R22 R36 null null 524 FLUORINE R7 R26 R35 null SHA j Rec 4 lt 4 1 gt i Number of records 11 The Database Query window is used to create and apply various filters Add a query Database Manager must be open to the Fields tab in the Database Query window Chapter 4 20 Database Manager User manual 1 Click Add query 2 Enter a name for the query 3 Click OK Select deselect one or more fields Database Manager must be open to the Fields tab in the Database Query window To select or deselect one or more fields click on the button next to 1 2 3 or 4 in the navigation tool l k k AWN Click Query Modify the order of fields selected Database Manager must be open to the Fields tab in the Database Query window 1 Click the required field in the Ordered fields window 2 Click the Up or Down arrow to reach the required data Database Queries Chapter 4 21 AND Ordered fields NAME t RISKR1 RISKR2 4 RISKA RISKA4 RISKS RISKS2 RISKS3 3 Click Query For a better view of the query application you can increase the size of the data display area by reducing the height of the Fields Filter and SQL Query tabs Create a filter using predefined data Database Manager must be open to the Filter tab in the Database Query window 1
21. x cb Database Structure File DVD Label Ibl g ate WW Designer Printer Name i KERES d Edit Database 2 amp i T i G Printer Microsoft XPS Docun y eo oe z gt PAE LMT 90 D zuke bed i Database Query aa Print v ja BO HOZ BO Quantity NAME RISKR1 RISKR2 RISKR3 RISKR4 RISKS1 RISKS2 gt Jo 11 1 TRICHL R20 null null null 524 25 null 0 1 234TETR R1 R20 21422 null null 35 null 0 He 4 hea elven R36 38 null null 35 null 0 1 2 DIAMINO R10 R21 22 R34 R43 59 526 0 BENZENE R45 R11 R23 24 25 null 53 S16 0 CAPTAFOL R45 R43 null null 53 S44 0 CYANAZINE R22 null null null 22 537 0 CYCLOBUTA R11 null null null 59 S16 0 ENDOSULFA R24 25 R36 null null 28 536 37 0 FENSON R22 R36 null null 24 26 0 FLUORINE R7 R26 R35 null 57 9 536 lt il Rec 4 a 1 i Number of records 11 The Print window is used to select files for printing to assign printers and to define various parameters before printing is launched Chapter 5 28 Database Manager User manual Display options Database Manager must be open in the Print window Click Settings BR Settings Preview the document Database Manager must be open in the Print window Click Preview Preview Display the label design software Database Manager must be open in the Print window Click Designer Designer Select a document to be printed Create a new Database Manager must be open in the P

LABELVIEW 2014 – Database Manager

Contents

Download Pdf Manuals

Related Search

Related Contents

LABELVIEW 2014 &ndash; Database Manager

Contents

Download Pdf Manuals

Related Search

Related Contents

LABELVIEW 2014 – Database Manager