Braton Group Database Manager Manuel d'utilisateur

D A T A B A S E M A N A G E R U S E R M A N U A L

CHAPTER 2Database file structureDatabase Structure windowThe Database Structure window is used to manage thestructure of the database file: to add, mo

Chapter 2 - 8 Database Manager - User manualChoose a database from the list of connectionsDatabase Manager must be open in the DatabaseStructure windo

Database file structure Chapter 2 - 93 Click OKYou can also copy the structure of the table from a table thatalready exists in the selected database.

Chapter 2 - 10 Database Manager - User manual3 Click Delete tableView/hide active table’s dataDatabase Manager must be open in the DatabaseStructure

Database file structure Chapter 2 - 114 Click ApplyDefine a field’s maximum sizeDatabase Manager must be open in the DatabaseStructure window. 1 Clic

Chapter 2 - 12 Database Manager - User manual2 Click Apply

CHAPTER 3Database contentsEdit Database windowThe Edit Database window is used to manage the contentsof the database file: to add, modify or delete da

Chapter 3 - 14 Database Manager - User manualSelect records according to their contentUse the content of a field to find a recordDatabase Manager must

Database contents Chapter 3 - 155 Click on the Select all button NoteYou can also specify the filter by clicking on the ’Check case’ button. Select a

Chapter 3 - 16 Database Manager - User manualFind a record according to its row in the tableDatabase Manager must be open in the Edit Databasewindow.

The information in this manual is not binding and may bemodified without prior notice.Supply of the software described in this manual issubject to a u

Database contents Chapter 3 - 17Modify a recordDatabase Manager must be open in the Edit Databasewindow. 1 Click on the data you want to modifiy2 Ent

Chapter 3 - 18 Database Manager - User manualNoteTo sort records in descending order, click on the same field again. Delete a recordDatabase Manager m

CHAPTER 4Database queriesDatabase Query windowThe Database Query window is used to create and applyvarious filters. Add a queryDatabase Manager must b

Chapter 4 - 20 Database Manager - User manual1 Click Add query2 Enter a name for the query3 Click OKSelect/deselect one or more fieldsDatabase Manag

Database queries Chapter 4 - 213 Click QueryNoteFor a better view of the query application, you can increase the size of the data display area by red

Chapter 4 - 22 Database Manager - User manual5 Click in the Operator field6 Click the drop-down list button7 Click on the value required

Database queries Chapter 4 - 238 Click in the Value field9 Enter the value required10 Click QueryTable 1: Description of operator functionsOperator

Chapter 4 - 24 Database Manager - User manualApply a logical operator to several filtersDatabase Manager must be open at the Filter tab in theDatabase

Database queries Chapter 4 - 25Remove a filterDatabase Manager must be open at the Filter tab in theDatabase Query window. At least one filter must ex

Chapter 4 - 26 Database Manager - User manual2 Click QueryNoteThe filter can be created directly in SQL without having to use the Filter tab first. C

Table of ContentsChapter 1: Connecting to database files . . . . . . . . . . . . . . . . . . . . . . . . . 1-1Database Connections window . . . . .

CHAPTER 5PrintingThe Print windowThe Print window is used to select files for printing, to assignprinters and to define various parameters before prin

Chapter 5 - 28 Database Manager - User manualDisplay optionsDatabase Manager must be open in the Print window.1 Click OptionsPreview the documentDatab

Printing Chapter 5 - 29NoteCreating a label in relation to the database allows you to define exactly which elements are required to position each data

Chapter 5 - 30 Database Manager - User manual1 Click on the Printer settings button2 Adjust the required settings3 Click OKSelect records to be prin

Printing Chapter 5 - 31Selecting records automaticallyDatabase Manager must be open in the Print window.1 Click the drop-down list button2 Click on t

Chapter 5 - 32 Database Manager - User manualDisplay the selected printer’s propertiesDatabase Manager must be open in the Print window.1 Click on the

Printing Chapter 5 - 33Launch printingDatabase Manager must be open in the Print window. Alabel template and printer must be selected. The records tob

Chapter 5 - 34 Database Manager - User manualAllow the database to be editedDatabase Manager must be open in the Print window. Alabel template and pri

IndexAAdd a query , Chap 4-19Add a table 8automatically , Chap 5-31CChoose a database 8Connect , Chap 1-1Create , Chap 3-16Ddatabase , Chap 2-8Databas

Chapter 6 - 36 Database Manager - User manualFind , Chap 3-15Find a record , Chap 3-14Hhide , Chap 2-10Hide table , Chap 2-10Iidentical records , Chap

ii Database Manager - User manualChapter 4: Dat

Index Chapter 6 - 37Printer settings , Chap 5-30Printing , Chap 5-27printing , Chap 5-33RRemove , Chap 1-5Remove a connection 5Remove filters , Chap 4

Copyright 2012 Teklynx Newco SAS. All rights reserved. Printed in the USA 06/12. TEKLYNX and CODESOFT are trademarks of Teklynx Newco SAS. Allother br

CHAPTER 1Connecting to database filesDatabase Connections windowFigure 1 The Database Connections window is used to connect thesoftware to the various

Chapter 1 - 2 Database Manager - User manual1 Go to File > Open. A File selection dialog box will open allowing you to browsefor and select the da

Connecting to database files Chapter 1 - 36 Select the required provider7 Click Next >>NoteThe choice of provider changes according to the sys

Chapter 1 - 4 Database Manager - User manual11 Click OK12 Click Next13 Enter a name for the connection14 Click Finish

Connecting to database files Chapter 1 - 5NoteYou can repeat this procedure as often as necessary to obtain the required number of connections. Modify