Database Manager User manual
Contents
1. Click the search tool s data input field Enter the data required Rec affe bo 18 Create a new record Database Manager must be open in the Edit Database window Click on a field in the row marked with an asterisk Enter the values required in the corresponding fields Click Apply gt ie null null null null null Modify a record Database Manager must be open in the Edit Database window Click on the data you want to modifiy Enter the data required Click Apply 19 Sort a series of records by alphanumerical order Database Manager must be open in the Edit Database window There must be at least two records in the table Click on the name of the field required LOTNUM LOTNUM 7 LOTNUM 1011 0994 1030 1001 1001 1026 0999 1002 1025 1009 1002 1024 1007 1004 1023 1005 1005 1011 1004 1007 1004 103 1024 1011 1005 1002 1004 1002 1002 1025 1002 1026 1001 1030 1030 04994 ae Ole aaa To sort records in descending order click on the same field again Delete a record Database Manager must be open in the Edit Database window Click the database cursor for the required field Right click the database cursor for the required field Click on Delete Record in the context menu Delete selected record s 005 golf 21 CHAPTER 4 DATABASE QUERIES Database Query window fi Database Manager Jeep 4x4 1011 jeep bmp 1475 Autobus 1001 autobus bm2. 1 1 ce ee 5 39 SOD PIMING 24 5 5 0565 0ie5umadedutek e pe ee See eet A 5 39 Refresh database VICW 2 eee tenes 5 39 Close ad documen 3254 2 weet tact sti wos eh eee we Slee eat 5 40 Ghapter 6 INdGX o2c4 och ey ee chee eee Ae tea a era eet 6 41 CHAPTER 1 CONNECTING TO DATABASE FILES Database Connections window The Database Connections window is used to connect the software to the various database files that are to be used Connect the Database Manager module to the database Database Manager must be open in the Database Connections window eS es 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 Click Add Select a database type from the list or Select Others Click Connection Setup Add database connection Advanced mode Connection setup Connection string Provider Microsoft Jet OLE DB 4 0 Data Source C Program Files Codesoft 8 S amples Labels Fruits mdb Persist S ecurity Info F alse Back Next Finish Cancel Click the Provider tab of the dialog box Select the required provider E Data Link Properties Ea Provider Connection Advanced An Select the data you want to connect to OLE DE Providers MedialatalogDB OLE DB Provider MediaCatalogM
3. Conditions table Logical Fi Operator Click in the Field field Click the drop down list button Click on the data required UNITSPERBS Click in the Operator field Click the drop down list button 25 Click on the value required Operator Tableau 1 Description of operator functions ee O e l e NOT BETWEEN 26 Click in the Value field Enter the value required Trailor imla re Click Query Apply a logical operator to several filters Database Manager must be open at the Filter tab in the Database Query window Several filters must exist Click in the Logical field Click the drop down list button Click on the data required Logical Click Query to apply and view the changes 27 Sort the list of filters Database Manager must be open at the Filter tab in the Database Query window Several filters must exist Click on the database cursor for the required field Click on the Up or Down arrow to reach the data required Fields Filter SQL Query Select filba Conditions table Logical Field Operator Value MAME Trailor LOTNUM 15000 MAME Lusury Remove a filter Database Manager must be open at the Filter tab in the Database Query window At least one filter must exist Click on the database cursor for the required field Click on the Remove row button Fields Fiter SQL Query Select filte Conditions table Logical NAME Trailor
4. L rn gi Click Apply 13 Allow an empty field Database Manager must be open in the Database Structure window Tick the Allow Null box for the required field Click Apply 14 CHAPTER 3 DATABASE CONTENTS Edit Database window pf Database Manager ar fal EC Cancel Jeep 4x4 1011 jeep bmp 1275 Autobus 1001 autobus bmp 1 100 Trailor 0999 trailor bmp 1 100 Decker 1009 decker bmp 1 100 Fiat Blue 1007 fiat bmp 1 75 Golf 1005 golf bmp 1 75 Mercedes 1004 mercedes bm 1 75 Luxury 1023 luxury bmp 1275 Old 1024 old bmp 1275 Porsche 1002 porsche bmp 1 75 Car Red 1002 red bmp 1275 Truck Red 1025 truckRed bmp 1 75 Truck Yel 1026 truckyel bmp 1 75 Van 1030 van bmp 1 75 The Edit Database window is used to manage the contents of the database file to add modify or delete data These actions depend on the type of database Thus Excel file records cannot be modified Select records according to their content Use the content of a field to find a record Database Manager must be open in the Edit Database window Click the drop down list button Click on the data required Click the data input field Enter the value required in the data input field eA Database Manager autobus bmp 1 100 trailor bmp 1 100 decker bmp 1 100 fiat bmp 1 75 golf bmp 1 75 mercedes bm 1 75 luxury bmp 1 75 old bmp 1475 Porsche porsche bmp 1 75 Car Red red bmp 1 75 TruckRed 1025 tuckRed bmp 1 7
5. LOTNUM 15000 NAME Luxury 28 Modify a filter in SQL Database Manager must be open at the SQL Query tab in the Database Query window At least one filter must exist Tick the box next to Modify the query in SQL language to activate the SQL Query and make manual changes Fields Fiter SQL Query Select SQL que odity the query in SQL language SELECT PARTNUM NAME LOTNUM LOGONAME SCALE UNITSPERB FROM TOS Click Query 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 Click on the Query drop down list Click on the data required 29 Quern ftest The query selected can be modified later 30 CHAPTER 5 PRINTING The Print window Database Manager Ol S xs Zebra R402 gt COM1 alcii E Ne Mo eo pept i wn SH m a o mme 00 D jo 10080 Taio aaoo fso o o ome o meone a O D o 10750 FitBle 1007 Heo m ar mo o owe vO n L lo 24766 Mercedes Heo am uano ms kep I to ane oo ee ee eee eee eee eee tO __Pescine_ 1002 _prsche bre U The Print window is used to select files for printing to assign printers and to define various parameters before printing is launched 31 Display options Database Manager must be open in the Print window Click Options Options Preview the document Data
6. records to be printed Selecting records manually Database Manager must be open in the Print window Tick the boxes next to the records required al fale ILO le Quantity PARTNUM NAME jo 24560 Bi 10570 Bhi 10080 Ll 10580 mii 10750 Le 24200 im 24766 l 24256 23112 iA 25108 Ti 24321 10 24425 10 24426 10 24596 Note Jeep ded Autobus Trailor Decker Fiat Blue Galf Mercedes Luxury Old Porsche Car Red Truck Red Truck re Var LOTNUM 1011 1001 0399 1009 1007 1005 1004 1023 1024 1002 1002 1025 1026 1030 LOGONAME SCALE jeep bmp autobus bmp trailor brop decker bmp flat orp golt brp mercedes brn lusu brp old bmp porsche bmp red bmp tuckAed brn tuckyel bmp van bmp 175 1 100 1 100 1 100 1 75 1 5 1775 1775 1775 1775 1775 1775 1775 1775 UNITSPEI 100 The height of the data display grid can be modified by dragging the top of the window 35 Selecting records automatically Database Manager must be open in the Print window Click the drop down list button Click on the data required Click on the data input field Enter the data required Click on the Select all button Click on the Verify button JLOTNUM fine ealSOILIL 7 e Quantity PARTNUM NAME LOTNUM LOGONAME SCALE UNITSPEl 0 24560 Jeep dud 1011 jeep bmp 75 100 0 10570 Autobus 1001 autobus bmp 1 100 Al 0 10080 Trailor 0999 trailor Em
7. 10 Type 13 type of content 13 View table 12
8. 5 Truck Yel 1026 truckyelbmp 1 75 Van 1030 yan bmp 1 75 Select all identical records Database Manager must be open in the Edit Database window and at least one record must have been found Click the drop down list button Click on the data required Click the data input field Enter the data required in the data input field Click on the Select all button iz Database Manager Ta ia fisse SJB frovs fou A hile RTM i Jeep 4x4 1011 jeep bmp 175 100 Autobus 1001 autobus bmp 1 100 50 Trailor 0999 trailor bmp 1 100 50 Decker 1009 deckerbmp 1 100 50 Fiat Blue 1007 fiat bmp 1 75 100 Golf 1005 golt bmp 1 76 100 E 24766 Mercedes 1004 mercedes bm 1 75 100 I 24256 Luxury 1023 uxuy bmp 1275 100 23112 Old 1024 old bmp 1 75 100 Set tates eg m 24321 Car Red 1002 ted bmp 1 75 100 PA TuckRed 1025 truckRed bmp 1 75 80 T 24426 Truck Yel 1026 truckyelbmp 1 75 80 24596 Van 1030 yan bmp 1 75 100 You can also specify the filter by clicking on the Check case button 17 Select an identical record 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 on 1 First 2 Previous 3 Next or 4 Following Rec H a E F 1 2 3 4 Find a record according to its row in the table Database Manager must be open in the Edit Database window
9. Database Manager User manual DMAN US 08 11 05 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 Braton Groupe sarl 2005 Braton Groupe sarl All rights reserved TEKLYNX and its products are registered trademarks of Braton Group Sarl or its subsidiaries All other trademarks and product names are the property of their respective owners Table of Contents Chapter 1 Connecting to database files 1 3 Database Connections WINdOW 0 0 00 cc eee 1 3 Connect the Database Manager module to the database 1 4 Modify the database connection parameters 000 eens 1 7 Remove a connection 0 0 0 0000 cc ee 1 8 Chapter 2 Database file structure 0000 e eens 2 9 Choose a database from the list of connections 05 2 10 Choose a table in a database annaua uaaa ee 2 10 Add a table to the active database 0 0 a a 2 11 Delete a table in the active database 0 000 cee eee 2 12 View hide active table s da
10. Finish S 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 Click Edit Make the required changes Remove a connection Database Manager must be open in the Database Connections window The required connection must be selected I ap rity Click Remove CHAPTER 2 DATABASE FILE STRUCTURE Database Structure window L jei n l FIRSTNAME 0 g Sp N a ADDRESS STATE Ob w Zp oa LABNAME SERIAL_QTY e Name JE char 25 M O E v a E char M O v E BEL STATE o varchar ft el a E enar O m v C i iv O m v a a The Database Structure window is used to manage the structure of the database file to add modify or delete tables fields etc Choose a database from the list of connections Database Manager must be open in the Database Structure window Click on the Database drop down list Click on the data required OD atab ase Batcher E B abcher wo T ovs dE ase Toys E scel Choose a table in a database Database Manager must be open in the Database Structure window Click on the Table drop down list Click on the data required Table Identity Identity Jt Tops Un 10 Add a table to the active databa
11. base 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 32 Select a document to be printed Create a new label template for printing Database Manager must be open in the Print window Click on the Create labels wizard button BEBE Follow the wizard s instructions Eos Creating a label in relation to the database allows you to define exactly which elements are required to position each database field Select an existing label template Database Manager must be open in the Print window Click on the Open an existing document button ojele Select a lab file Click OK MEES The Field radio buttons in the Label name and Printer name groups of options allow you to choose the label or printer required when the latter are defined in one of the fields of the active database 33 Select a printer Database Manager must be open in the Print window A label template must be selected Click on the Add or remove a printer button 3 a Select the printer required 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 Click on the Printer settings button alil Adjust the required settings Click OK 34 Select
12. engedDB OLE DB Provider MediaCatalogyebOB OLE OB Provider Microsoft ISAW 1 1 OLE OB Provider Microsoft Jet 3 51 OLE OB Provider Microsoft Jet 4 0 OLE OB Provider Microsoft OLE DB Provider For Data Mining Services Microsoft OLE DB Provider for Indexing Service Microsoft OLE OB Provider for Internet Publishing Microsoft OLE DB Provider for ODBC Drivers Microsoft OLE OB Provider for OLAP Services Microsoft OLE OB Provider for OLAP Services 6 0 Microsoft OLE OB Provider for Oracle Microsoft OLE OB Provider for SQL Server Microsoft OLE DB Simple Provider Microsoft Project 9 0 OLE OB Provider MSD ataShape OF Annuler Alide Click Next gt gt The choice of provider changes according to the system s type of database Click the search button Select a file Click Open B3 Data Link Properties Provider Connection Advanced All Specify the following to connect to Access data 1 Select or enter a database name C Program Files Codesott 65 5 amples Labels Fruits mc 2 Enter information to log on to the database User name Admir Password W Blank password D Allow saving password Test Connection Click OK Click Next Enter a name for the connection Add database connection Finish Gua Connection name fruity Connection string Provider MSDASOL 1 Persist Security Info False Data Source Fruits Advanced Back ext Finish Cancel Click
13. ka teh bod tick eed a he hee Soe oh dene 4 28 Modify a filter in SQL 224 secu sacks se boa es ee dae eke Sete 4 29 Choose an existing query ina database 000 0c eee eeee 4 29 Chapter 5 Printing sors sincseeturbiGaa ren tess Sede ele ee wy ete ze 5 31 DI pay ODON S serea a eo eed Co ea ee ee 5 32 Preview the document 0000 c cece eee eee eee eens 5 32 Display the label design software 0 00 00 cece eee ee eee 5 32 Select a document to be printed 1 2 0 cee 5 33 Create a new label template for printing 005 5 33 Select an existing label template 0 00 e eee eee 5 33 Select a printer nannan aia 4s tees ee ee ee th eros Oa ees 5 34 Configure the selected printer 000 cece eee eens 5 34 Select records to be printed 1 1 ee 5 35 Selecting records manually 00 cece eee eee eee eee 5 35 Selecting records automatically 0 00 cee eee eee 5 36 Configure the print media 2 22 3 s teenic0 bated bos eaciGue es 5 36 Display the selected printer s properties 000000 0 5 37 Define the number of printed pages according toafield 5 37 AUCH PANUNG eis6 te oe bo ote dk a eto aE ee Net a a Be tea reek 5 38 Launch printing manually each time naana anaana aaa 5 38 Update variable with database annann 5 38 Merge Database attached to document 2000 0c eee 5 38 Allow the database to be edited
14. p 1 100 Trailor 0999 trailor bmp 1 100 Decker 1009 deckerbmp 1 100 Fiat Blue 1007 fiat bmp IAS Golf 1005 golf bmp 1275 Mercedes 1004 mercedes bm 1 75 Luxury 1023 luxury bmp 1275 Old 1024 old bmp 1 75 Porsche 1002 porsche bmp 1 75 Car Red 1002 ted bmp 1 75 The Database Query window is used to create and apply various filters Add a query Database Manager must be open at the Fields tab in the Database Query window Click Add query Enter a name for the query Click OK Select deselect one or more fields Database Manager must be open at 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 b ke UN Click Query 23 Modify the order of fields selected Database Manager must be open at the Fields tab in the Database Query window Click on the required field in the Ordered fields window Click on the Up or Down arrow to reach the data required AAD Ordered fields PAR TMU MAME LO TNO pA LOGONAME SCALE UNITSPERBS Click Query ae OL 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 24 Create a filter using predefined data Database Manager must be open at the Filter tab in the Database Query window Click on the Add row button Fields Fiter SOL Query Select filte
15. p 17100 zi 0 10580 Decker 1009 deckerbmp 1 100 50 0 10750 Fiat Blue 1007 fiat bmp 1 75 100 0 24200 Golf 1005 golf brip 1 75 100 0 Mercedes 1004 mercedes bmn 1 75 100 Porsche 1002 porsche bmp 1 75 100 1002 red bmp 1 75 100 truckyel brip a5 BO van bmp 1275 100 Configure the print media Database Manager must be open in the Print window A document must be selected Click on the Page setup button D sixa 36 Display the selected printer s properties Database Manager must be open in the Print window Click on the Page setup button Click Settings Settings Define the number of printed pages according to a field Database Manager must be open in the Print window and a printer must be selected Records to be printed must also be selected Click on the Quantity column drop down list Select the data required Click the selected data s drop down list button Select the required value or enter a whole numeric value 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 37 Launch printing Database Manager must be open in the Print window A label template and prin
16. se Database Manager must be open in the Database Structure window Click Add table Enter the name of the new table Click OK Add table Oe x Table Hame Toys l Duplicate with identity a You can also copy the structure of the table from a table that already exists in the selected database To do so Tick the box next to Duplicate with Click on the drop down list Click on the data required Click OK Add table o Table Name IT opg Duplicate with i OWS 11 Delete a table in the active database Database Manager must be open in the Database Structure window Click on the Table drop down list Click on the data required T able identity Identity qt Toys Click Delete table View hide active table s data Database Manager must be open in the Database Structure window Click View data Define a key field Database Manager must be open in the Database Structure window Tick the box next to the required field Dri eo l NA Click Apply 12 Define a field s type of content Database Manager must be open in the Database Structure window Click on the required field in the Type column Click the drop down list button Click on the data required Varchar Decimal Mema Click Apply Define a field s maximum size Database Manager must be open in the Database Structure window Click on the required field in the Length column Enter the value required
17. ta 0 0 0 eee 2 12 Delme a keyTleld ccssenbbedatee Gomdechwaeciesaee 4 eee obo uees 2 12 Define a field s type of content 0 0 cee ee 2 13 Define a field s maximum SIZE 0 ee 2 13 Allow an empty field 0 0 0 eee eee 2 14 Chapter 3 Database contents 00 cece eee eee eee 3 15 Select records according to their content 000 ee eeee 3 16 Use the content of a field to find a record 0000 3 16 Select all identical records naana aaa ee 3 17 select an identical recordes Ade we eee ee Mew eee ee BAS 3 18 Find a record according to its row inthe table 485 3 18 Greate a New record ea fot eee bare be oda dh bot e e ge da ee eas 3 19 MOGI areco io wrist a Sahn Ae aes teeta lee ose eee eee 3 19 Sort a series of records by alohanumerical order 3 20 Delete a 1eCOrd 2 tack enn i na oh Sa thw ae ees bb Mee eee Shes hens 3 21 Chapter 4 Database queries 0002 cece eee eee ees 4 22 POG AGUEN Sarta 9c ek einen tne Carb aM a ieba NE e ae ae Ge uA 4 23 Select deselect one or more fieldS 0 0 0 0 cece eee 4 23 Modify the order of fields selected 0 0 0 0 c eee 4 24 Create a filter using predefined data 0 0 00 cee eee 4 25 Apply a logical operator to several filters 2 2 0 0 0 cece 4 27 SOM ANE IST OF TINCT Scale ots Gee bo ar oe ee abe ni he Se a wea Gee Sees 4 28 Removed TING it e
18. te 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 A 39 Close a document Database Manager must be open in the Print window A label template must be selected Click on the Documents drop down list Click on the data required Click the Close current document button 0 oxi 40 Index Add a query 23 Add a table 11 automatically 36 Choose a database 10 Connect 4 Create 19 database 10 Database Connections 3 Database Query 22 Database Structure 9 Delete 21 Deselect 23 document to be printed 33 Duplicate with 11 Edit Database 15 empty field 14 existing query 29 field s maximum size 13 filter 25 Find 18 Find a record 16 hide 12 Hide table 12 identical records 17 41 key field 12 label design software 32 label template 33 manually 35 Merge Database 38 Modify 19 Modify a connection 7 Modify filter 29 N new record 19 null field 14 O options 32 Ordered fields 24 P Page setup 36 Preview 32 preview 32 Print 31 print media 36 printer 34 printer properties 37 Printer settings 34 Printing 31 printing 38 Remove 8 Remove a connection 8 Remove filters 28 search tool 18 Select 16 23 Select records 16 35 Select deselect 23 selecting a provider 5 software 32 Sort 20 Sort filters 28 SQL 29 table
19. ter must be selected The records to be printed must also be selected Click the Print records button g pP Bl 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 Tick the box next to Display the print dialog box between each record Click the Print records button Update variable with database 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 Tick the box next to Update variable with database Click the Print records button Merge Database attached to document 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 Tick the box next to Merge Database attached to document Click the Print records button 38 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 Tick the box next to Allow the database to be edited Click the Print records button Stop printing 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 Printing must have already been launched Click the Stop printing button
Download Pdf Manuals
Related Search