
- 155 -
DatabaseWizard–Formattingthefields
InthisstepoftheWizardyoucanreviewthefields'namesandlengthsandmodifythem,ifnec-
essary.Youwillprobablyusemorefriendlyfieldnames,soyoucandistinguishbetweenthemmore
easily.
WhenyouarefinishedwithTextFileWizard,thestructureinformationoftheusedtextfileisstored
toaseparatefilewithaextensionof.SCH(SchemeFile).Ifyouwilltrytousethesametextfile
someothertimeonadifferentlabel,youwillbesparedalleffortsofstructurecreating.SCHfile
willbeautomaticallyusedandTextFileWizardwillbeskippedentirely.
Note,thatSCHfileiscreatedalsowithadd-ondatabasemanagerNiceData,whenyouopenthetext
databaseinNiceDataforthefirsttime.
Linking a Label to Advanced Databases
Overview
Youcanusethelabelingsoftwaretoretrievedatafromanydatabaseonyourcomputerornetwork.
Ifyouhavetheappropriatedatabasedrivers,youcanconnecttothedatabaseandusetherecordson
thelabel.
Note:
DesignerExpressdoesnothavealldatabaseoptionsavailable.Youcanonlyusedatafromtextdata-
basesandExcelspreadsheetsin[[[UndefinedvariableVariables.EditionExpress]]].
Withthelabelingsoftwareyoucanconnecttoanydatabasetypeaslongasyouhavetheappropriate
databasedriversinstalledonyourcomputer.Thelabelingsoftwaresupportsdifferentdatabasedriv-
erslikeODBC,OLEDBandBDE.Yourcomputercomespre-installedwithdatabasedriversfor
frequentlyuseddatabasetypes,butyoucanalwaysinstalladditionaldrivers.
Youhavetotalcontroloverwhichrecordsinthedatabasetablewillbeprinted.Bydefaultallrec-
ordsareprinted,butyoualsohavetheoptiontoselecttherecordsforprinting.Beforethelabelsare
processedyoucanselecttherecordsinthetablethatyouwanttoprint.Youcanalsospecifythe
printquantityforeachrecord.
Advancedrecordselectiontechniquesarealsoavailableinthelabelingsoftware.Youcancreate
databasefiltersandobtainonlytherecordsthatmatchtheconditions.Thesamefunctionalityallows
youtojointwoormoredatabasetablestogetherandobtainvaluesforthesameproductfrommul-
tipledatabases.
ManualmodificationoftheSQLsentenceisavailableforadvancedusers.
Link to a Database Using Database Wizard
1.
Clickonthebutton intheStandardToolbar.TheDatabaseWizardwill
open.
2. SelecttheoptionDirect database accessandclickontheBrowsebutton.
UsetheoptionDirectdatabaseaccess,ifyouusefile-baseddatabaseslikeMicrosoft
Access,Paradox,dBase,Excelor.TXTfiles.
Comentarios a estos manuales