pdf reader c# : How to erase text in pdf file control software system web page windows html console MapInfoProfessionalUserGuide43-part778

LimitationsofOLE
AlthoughMapInfoMapenablesyoutobuildamapveryeasilyinyourcontainerapplication,notallof
MapInfoProfessional'sfeaturesareavailableinthecontextofmapembedding.Amongthemareediting
mapobjectssuchasregionsorpolylines,queryingatableforfurtheranalysis,geocodingtoatablein
theMapwindow,ordisplayingtablesinBrowserwindows.
However,withMapInfoProfessional'sdraganddropcapabilitiesyoucanstillperformthesefunctions
inMapInfoProfessionalandbringovertheMapwindowtoyourOLEcontainerapplicationforfinal
viewing,formattingandeditingenhancements.
WorkingwithEmbeddedMaps
NowthatyouhavehadanintroductiontoMapInfoMapObjectandwhatitcandoforyouasyouwork
inanotherapplication,letusgetdowntothespecificsofembeddinganOLEobject.
Youneedtospecifywhatgetscopiedtotheclipboard.Bydefault,youcannotcopyamapuntil
yousetthispreference.SeeSettingYourCopytoClipboardPreferencesintheHelpSystem.
Note:
AlthoughcontainersvaryintheirhandlingofOLEobjects,therearesomebehaviorsthatarecommon
toall.TherearethreewaysthatcontainersacceptembeddedOLEobjectssuchasaMapwindow:
• OntheInsertmenu,clickObjecttochoosetheobjecttoembedfromalist.
• OntheEditmenu,clickPaste(orPasteSpecial)toembedanobjectthatwaspreviouslycopiedto
theClipboard.
• DraganddropfromtheapplicationtothecontainerusingtheDragMapWindowtool.
Themethodyouchoosedependsonwhichapplicationyouareinatthemoment(serverorclient)and
howmuchyouwanttodotocreatethefinalmap.
• Formoreinformationandrelatedtopics,seeCreatingaNewMapWindowinyourContainerand
BringingaMapWindowintoyourApplicationintheHelpSystem.
SharingDocumentswithEmbeddedMaps
Onceyouhavecreatedamapinyourdocument,youmaywanttoshareitwithacolleague.Oryoumight
wanttouseitonanothersystem.Whenthedocumentisopenedonanothersystem,theMapInfoMap
Objectdisplaysasametafile,orpictureofthemap,intheinactivestate.Themapislikeanyothergraphic
imageatthispoint.Ifnomapeditingisnecessary,thedocumentcanbeprinted,reformatted,reorganized,
andsavedwithnospecialhandlingrequiredforthemap.Themapitselfcanevenberesizedor
repositioned.Youcannot,however,changethecontentofthemapsinceitisnotanactiveOLEobject.
Toactivatethemapforeditingonanothersystem,yourcolleaguemusthaveaccessto32-bitMapInfo
Professionalandthedatausedtocreatethemap.Double-clickthemaptoactivatetheOLEobject.
MapInfoProfessionalwillpromptforthelocationofthedatafilesifitcannotfindtheoriginallocation.If
thedataisnotavailable,canceloutoftheLocateDatadialogbox.Themetafileimageisreplacedwith
theMapInfoProfessionalworldmapintheactivestate.Toretrievetheoriginalmetafileimage,closethe
documentwithoutsavingandreopeningit.
SharingMapInfoProfessionalandmapdataonothersystemsislimitedtotheextentofyour
licenseagreement(s).
Note:
• Formoreinformation,seeMapInfoMapObjectsvs.DataMapObjectsintheHelpSystem.
431
MapInfoProfessionalUserGuide
Chapter17:SpecializedTopicsinMapInfoProfessional
How to erase text in pdf file - delete, remove text from PDF file in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Allow C# developers to use mature APIs to delete and remove text content from PDF document
pull text out of pdf; how to delete text in pdf using acrobat professional
How to erase text in pdf file - VB.NET PDF delete text library: delete, remove text from PDF file in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
VB.NET Programming Guide to Delete Text from PDF File
delete text pdf; how to remove highlighted text in pdf
UsingMapInfoTableswithDataMap
DataMapusesMapInfoProfessionaltables.AllofthesamplemapsprovidedwithDataMapareactually
MapInfoProfessionaltables.
IfyouhavecreatedyourownMapInfoProfessionaltables,youcanuseyourtablesinDataMap.However,
beforeyoucandisplayyourtableinDataMap,youmustsetupyourtableusingtheDataMapData
Installer.TolaunchtheDataInstaller,double-clickthefileDATAINST.EXE.(Tolocatethisfile,click
WindowsStart,andthenclickFind.)OnceyouhavelaunchedtheDataInstaller,completethedialog
boxesthatappearonthescreen.
NotethatsomeMapInfoProfessionaltablescannotbeusedwithDataMap.Specifically:
• DataMapcannotdisplayrasterimageunderlaytables.
• DataMapcannotdisplayatablethatisactuallydefinedasarelationaljoinofothertables(suchasa
PitneyBowesSoftwareInc.StreetProtable).TouseastreettablewithDataMap,useMapInfo
Professional'sSaveCopyAscommand,whichsavesastreettableina"flat"formthatDataMapcan
use.
• DataMapcannotdisplaypointobjectsthatuseMapInfoProfessional"Custom"symbolstyles.(Custom
symbolsareselectedbydisplayingMapInfoProfessional'sSymbolStyledialogbox,andthenselecting
"CustomSymbols"fromtheFontdrop-downlist.)IfyourMapInfoProfessionaltablecontainspoints
withcustomsymbolstyles,thosepointswillbeinvisibleinDataMap.
FormoreinformationaboutDataMap,seetheDataMapHelpSystem.Formoreinformationaboutthe
DataInstaller,seetheDataInstallerHelpSystem.
Internet ConnectivityandMapInfoProfessional
MapInfoProfessionalcontainsoptionsthatallowyoutobringtheInternetintoyourmappingsessions,
andtobringyourmapstotheInternet.
UsingactiveobjectsandtheHotLinktool,youcanlaunchfilesandInternetURLsdirectlyfromobjects
orlabelsonyourmap.Activeobjectsprovideyouwithapowerfuldisplaytoolthatallowsyoutobring
informationfromtheWebandotherapplicationstogetherinyourmap.
Theseadditionalsourcesofinformationcangiveyouranalysisorpresentationgreaterimpact.For
example,youcanlinkalocationonyourmaptoaWebsitethatgivesmoreinformationaboutthelocation
ortoanimagefilethatshowscertainaspectsofthelocationinmoredetail.
Inaddition,youcanusethemapsyoucreateinMapInfoProfessionalinyourWebpages.TheHTML
ImageMaptoolconvertsaMapInfoProfessionalmapintoanHTMLimagemap.VisitorstoyourWeb
pagewillbeabletoclickanyregiontolinktootherHTMLpagesspecifictothatregion.
WhatAreActiveObjects?
ActiveobjectsaremapobjectsthatareassociatedwithfilesorURLs.Thefilecanbeabitmap,aMapInfo
Professionalworkspaceortable,aMapBasicprogram,oranytypeofexecutablefilewhoseextension
isassociatedwithanapplicationinstalledonyoursystem.
MapInfoProfessional12.5
432
InternetConnectivityandMapInfoProfessional
C# PDF Text Redact Library: select, redact text content from PDF
application. Free online C# source code to erase text from adobe PDF file in Visual Studio. NET class without adobe reader installed.
how to delete text from a pdf in acrobat; how to delete text in pdf converter professional
C# HTML5 Viewer: Load, View, Convert, Annotate and Edit PDF
logo to PDF document, you and load and save it to current PDF file. Redact tab on viewer empower users to redact and erase PDF text, erase PDF images and erase
delete text from pdf; how to delete text from pdf
Theactiveobjectinthismap(redtriangle)islinkedtoawebcamwebsitethatdisplaysanerupting
volcano.
TheHelpSystemcontainstheseandotherrelatedtopics:
• AddingURLInformationtoyourTable
• CombiningaDistrict'sObjects
• CreatingActiveObjects
• CreatingMultipleHotLinksinaMap
• UsingtheHotLinkToolinaMapWindow
• SavingaNewDistrictandExitingtheRedistricter
HTMLLandingPages
TheLandingPagesoptionallowsyoutoclickanyregionintheHTMLimagemapandlinktoanHTML
landingpagespecifictothatregion.Youcanputwhatevercontentyouwantintothelandingpages,
includingcolumninformationfromyourtable.Theuserinterfaceenablesyoutoselectthecolumnsyou
wanttouseandcustomizethetext.
• FormoreaboutselectingcolumnsforlandingpagesandTooltips,seetheHelpSystem.
Redistricting-GroupingMap ObjectsintoDistricts
OnepopularuseofMapInfoProfessionalistogroupmapobjectswithacommonfieldintodistrictsor
territories.MapInfoProfessional'sRedistrictingfeatureallowsyoutocreatenewdistricts,realignexisting
433
MapInfoProfessionalUserGuide
Chapter17:SpecializedTopicsinMapInfoProfessional
C# WPF Viewer: Load, View, Convert, Annotate and Edit PDF
Insert text box to PDF file. • Draw markups to PDF document. PDF Protection. • Add signatures to PDF document. • Erase PDF text. • Erase PDF images.
remove text from pdf; how to copy text out of a pdf
C# WinForms Viewer: Load, View, Convert, Annotate and Edit PDF
Add text box to PDF file in preview. • Draw PDF markups. PDF Protection. • Sign PDF document with signature. • Erase PDF text. • Erase PDF images.
how to delete text from a pdf document; delete text pdf document
districts,allthewhiledoingcalculationsoftheattacheddataontheflyforinstantanalysisand
decision-making.
WhatisRedistrictingandHowCanIUseIt?
Redistrictingistheprocessofassigningmapobjectstogroups.Asyouassignmapobjectstogroups,
MapInfoProfessionalautomaticallycalculatestotalsforeachgroupofobjects,anddisplaysthetotals
inaspecialBrowserwindowcalledtheDistrictsBrowser.Thisprocessissometimesknownas
load-balancing.
Whenyouperformredistricting,youcreateanumberofdistricts.Theexactnumberofdistrictsneeded
dependsonthenatureofyourwork.Youcanassignauniquenametoeachdistrict;thus,ifyouwantto
workwithfourdistricts,youmightcallthedistrictsNortheast,Southeast,Northwest,andSouthwest.
EachdistrictappearsasonerowintheDistrictsBrowser.
TheDistrictsBrowserisdifferentfromotherBrowserwindowsinseveralrespects:
• YouonlycanselectonerowatatimefromtheDistrictsBrowser.YoucannotShift-click
toselect
multiplerows.
• TheDistrictsBrowseralwayshasonerowselected;youcannotcanceltheselectionofthisrowby
choosingUnselectAll.
• WhenyouselectarowfromtheDistrictsBrowser,thatrowbecomesthetargetdistrict.Thetarget
districtisthedistrictthatwillbeaffectedbysubsequentredistrictingoperations.
Onceyouhaveselectedatargetdistrict,youassignmapobjectstothatdistrictbyselectingthemap
objects.Youcanselectobjectsbypointingandclicking,orbyperformingqueriessuchasSQLSelect.
Whenyouselectmapobjects,MapInfoProfessionaltentativelyassignstheselectedobjectstothetarget
district.MapInfoProfessionalthenrecalculatesthetotalsforeachdistrict,anddisplaysthenewtotals
intheDistrictsBrowser.YoucanthenexaminethecontentsoftheDistrictsBrowsertodecidewhether
youwanttomakethedistrictassignmentspermanent.
Tocancelthetentativedistrictassignment,canceltheselectionofthemapobjects.
Tomakethetentativedistrictassignmentpermanent,chooseRedistrict>AssignSelectedObjects.
WhenyouchooseAssignSelectedObjects,MapInfoProfessionalstoresthetargetdistrict'snameinthe
rowsoftheselectedobjects.Thus,ifyouassignmapobjectstoadistrictcalledNorthwest,MapInfo
ProfessionalstoresNorthwestineachobject'srow.
Eachdistricthasitsownsetoffill,line,andsymbolstyles.Whenyouassignamapobjecttoadistrict,
theobjectsubsequentlyappearsinthestyleofthedistrict.Thus,ifyouchooseasolidbluefillforthe
Northeastdistrict,objectsthatyouassigntoNortheastappearinsolidblue.
Forexample,ifyouhavealayerofstates,youmightwanttocombinethestateboundariestocreate
salesterritories.Eachstaterecordincludesafield,TOT_SALES,whichcontainsthetotalsalesforthe
previousyear.YouwouldultimatelyliketosumuptheTOT_SALESfieldforeachstateinagivensales
territory.Redistrictingisgivesyouthetoolsforcreatingthesalesterritoryandcombiningthose
TOT_SALESfieldsfromeachstate'sdataintoonetable.
MapInfoProfessional12.5
434
Redistricting-GroupingMapObjectsintoDistricts
C# HTML5 PDF Viewer SDK to view, annotate, create and convert PDF
Able to protect PDF document from editing, printing, copying and commenting by setting PDF file permissions. Help C# users to erase PDF text content, images and
how to delete text from pdf reader; how to delete text from pdf document
C# PDF Image Redact Library: redact selected PDF images in C#.net
call our image redaction API to redact PDF images. as text redaction, you can specify custom text to appear How to Erase PDF Images in .NET Using C# Class Code.
how to erase pdf text; remove text watermark from pdf
TheSTATEStableusedinthisexampleisfromtheMapInfoProfessionalTutorialdata,which
isavailablefromthePitneyBowesSoftwareInc.website,http://go.pbinsight.com/webtutorials.
Note:
Butthatisonlyonepartoftheredistrictingprocess.TherealpowerliesintheDistrictsBrowserwhere
youcanseeon-the-flyupdatesofdistrictrecordcountsanddatatotalswhenyouclickamapobjectand
assignittoanotherdistrict.Thisallowsyoutoperformvisual"whatif"analysistoachievedistrict
realignments,aprocesssometimesreferredtoasloadbalancing.
Whenyouaresatisfiedwiththedistribution,youcanmakethedistrictassignmentspermanent.Later,
astheneedarises,youcanchangetheassignmentsandtryoutnewdistributions.
Redistrictingdoesnotcreatenewmapobjectsorpermanentlychangethestyleofthemapobjects.
Redistrictingissimplyadynamicgroupingtoolthatdisplaysmapobjectsthatsharethesamedistrict
informationasagroup.Whilethemapobjectsarenotpermanentlyaffected,youcanmakethedistrict
assignmentspermanentbysavingthetable.
Youcanredistrictanymappabletablecontainingregion,line,orpointobjects.Theredistrictmapwill
reflecttheappropriatefill,line,orsymbolstylefortheobjects.TheRedistricterlimitsthenumberof
districtsinatableto594.
Youcanuseredistrictinginawidevarietyofapplicationssuchascreatingandmanagingsalesterritories,
schoolorvoterdistricts,emergencyservicecoverageareas,deliveryroutes,naturalresourcemanagement
areas,etc.Useitwhereverthereisahighdegreeoffluctuatingdataandtheneedtotryoutdifferent
realignmentscenarios.
Youcanuseredistrictingwhetheryouneedtocreatedistrictsfromscratchorrealignexistingdistricts.
Beforewegetintotheprocess,however,therearetwokeyconceptstointroduce:theDistrictsBrowser
andTargetDistrict.
UsingtheDistrictsBrowser
TheDistrictsBrowseristhekeytotheprocessofcreatingandchangingdistricts.Whilelookinglikeother
BrowsersinMapInfoProfessional,theDistrictsBrowserisactuallyadynamicwindowthatallowsyou
tomakechangestothegroupsandrecalculatestotalvaluesonthefly.Youcanimmediatelyseethe
resultsofyourchanges.Youthenhavetheoptiontomakethechangespermanentorcontinuetotry
outnewdistrictrealignments.
TheBrowserwindowliststhedistrictsasspecifiedinyourtable,therecordcountforeachdistrict,and
aggregateexpressioncolumnsthatcontainthenettotalvaluesofyourdata.Youspecifythesecolumns
intheNewRedistrictWindowdialogboxwhenyoubegintheredistrictingsession.
435
MapInfoProfessionalUserGuide
Chapter17:SpecializedTopicsinMapInfoProfessional
How to C#: Special Effects
Erase. Set the image to current background color, the background color can be set by:ImageProcess.BackgroundColor = Color.Red. Encipher.
delete text pdf acrobat professional; how to delete text in pdf acrobat
Customize, Process Image in .NET Winforms| Online Tutorials
Include crop, merge, paste images; Support for image & documents rotation; Edit images & documents using Erase Rectangle & Merge Block function;
deleting text from a pdf; delete text in pdf file online
• Formoreinstructionsaboutcreatingandaddingredistrictingfeaturesandotherrelatedtopics,see
theHelpSystem.
ForadditionaltopicsinRedistricting,seeSettinguptheTargetDistrictintheHelpSystem.
UsingRedistricting
Whenyoucalculatethepercentageofpartialcolumns(suchaspopulationcolumnsthatciteincome,
gender,age,ethnicbackground,orreligiousaffiliation)youhavetwocalculationmethodsavailable.One
methodcalculatesthepercentagebycolumnsothatthesumofalloftheentriesineverycolumnwould
be100%.Anothermethodcalculatesthepercentagebyrowbasedonyourselectedrowentry(orsum
ofentries)sothateachpercentageentryintherowiscalculatedbasedonthatrow(orsumofentries).
Forexample,inthefollowingtable:
C
B
A
1
1
1
2
2
2
TheColumnmethoddeterminesthepercentagesofentriesinColumnA:
Percentage (A1)=A1/(A1 1 + A2) x 100%; Percentage e (A2)=A2/(A1 + A2) x x 100%
TheRowmethoddeterminesthepercentageforentriesA1andB1basedonC1asatotalcolumn:
Percentage (A1) = = A1/C1 x 100%; Percentage e (B1) = B1/C1 x x 100%
Selectingavalidbaseentry(orthesumoftheentries)iscrucialtoreturningmeaningfulresults.
Forexample,ifyouchooseavalueinapopulationcolumnandabasevaluefromanincome
column,yourresultswillnotbemeaningful.
Note:
• Formoreinformation,seeCreatingNewDistrictsandRedistrictingusingtheRowMethodintheHelp
System.
OptionsinRedistricting
TocontroltheorderofdistrictsintheDistrictsBrowser,ontheRedistrictmenu,clickOptions.The
RedistricterOptionsdialogboxdisplays.Chooseyourpreferredsortorderfromamong:mostrecently
used,alphabetical,orunordered.YoucanalsochoosetoshowtheBrowsergridlinesandsavethe
optionsasyourdefault.
Asmentionedearlier,theMostRecentlyUsedoptioncangreatlyaidyouifyouhavemoredistrictsthan
theDistrictsBrowsercandisplayinawindow.Wheneveryouselectamapobjectthatbelongstoadistrict
thatisnotcurrentlyvisibleintheBrowser,MapInfoProfessionalwillmovethatrecordnearthetopof
theBrowserwindow.Youcanthenmoreeasilysetthenewtargetdistrictorviewthechangesinthe
datafieldsasyoucarryoutyourload-balancingscenario.
MapInfoProfessional12.5
436
Redistricting-GroupingMapObjectsintoDistricts
.NET Imaging Processing SDK | Process, Manipulate Images
Provide basic transformation functions, like Crop, Rotate, Resize, Flip and more; Basic image edit function support, such as Erase Rectangle, Merge Block, etc.
how to delete text in pdf file; remove text watermark from pdf online
Changingthedisplayofyourdistrictsissimple.Clickthefillpattern,linestyle,orsymbolintheDistricts
Browserthatrepresentsthedistrict.TheRegionStyle,LineStyle,orSymbolStyledialogboxdisplays,
whereyoucanchangethetoolsusedtodisplaythedistrict.
Tosavethestylechanges,youmustsavetheredistrictingsessionasaworkspace.SaveTablewillonly
savethedistrictassignmentchanges.Thestylesbelongtoathematiclayer,nottothetableitself.The
districtchangesareappliedtothetableand,thus,canbesavedtothetable.
RecordswithNoGraphicObjects
Redistrictinginvolvesgroupingmapobjectsintodistricts.Ifyouareredistrictingatablethatcontains
recordsthatdonothavegraphicobjectsassociatedwiththem,keepinmindthatMapInfoProfessional
includesthemaswellintheDistrictsBrowser.Youcannotassigntheserecordstonewdistricts.They
willaffectyourdatacalculationswhenyoumoveobjectsintonewdistricts.
Ifyouhavenumerousrecordswithoutgraphicobjectsinyourtable,itmaybebesttocreateandsavea
subsetofthetableandruntheRedistricteronthenewtable.
CreatingExpressions
Formulatingexpressionsissomethinglikewritingsentences.Thereisavocabularyofwordsfromwhich
youcandraw,andthesewordshavetobecombinedaccordingtosyntacticrules.Thesyntaxof
expressionsismuchsimplerthanthesyntaxofEnglish,andthevocabularyisvastlysmaller.However,
mostofushavebeenusingEnglishforyearsandsoitseemseasyandnaturalwhereasformulating
expressionsis,atfirst,sometimesabitdifficult.
However,justasEnglishhassimplesentencesandcomplexsentences,sotherearesimpleexpressions
andcomplexones.Evenifyoudonotgetthehangofformulatingcomplexexpressions,youcanstill
usealltheMapInfoProfessionalcommandsthatuseexpressions.Thatisbecauseformulatingsimple
expressionsisveryeasyand,atthesametime,allowsyoutoworkwithyourdatainpowerfulways.
• MostoftheproceduralinformationforCreatingExpressionsisavailableintheHelpSystem.
WhereExpressionsCanBeUsed
UsetheExpressiondialogboxtoformulatemathematicalandalphanumericexpressionsinseveral
MapInfoProfessionaldialogboxes.SeeSpecifyinganExpressionintheHelpSystem.
Expressionsareusedinthefollowingcommands:Select,UpdateColumn,ThematicMapping,andLayer
Control(double-clickthelayerandselectfromtheLabelwithlistontheLabelDisplaytab).The
expressionservesadifferentpurposeindifferentcommands.
Forexample:
IntheSelectcommandtheexpressionstatesaconditionthatarecordinatablemustmeetinorderto
beincludedinaquerytable.
• InUpdateColumntheexpressioncalculatesavaluethatisthenenteredintoatable.
• InThematicMappingtheexpressioncalculatesavaluethatisthendisplayedonamap.
• InLabelOptions,youuseexpressionscontainingstringfunctionstofinetuneyourlabels.
Theexpressionsfallintotwobroadcategories:
• Expressionsthatmustevaluatetotrueorfalse.
• Expressionsthatsimplycalculatesomevalue.
Expressionsthatmustevaluatetotrueorfalsealwayshaveacomparisonoperatorandmayhavemultiple
clausesconnectedbylogicaloperators.Usetheseexpressionsforselectingobjects.
437
MapInfoProfessionalUserGuide
Chapter17:SpecializedTopicsinMapInfoProfessional
Expressionsthatsimplycalculatesomevalueneverhaveacomparisonoperatorandgenerallydonot
havemultipleclauses.UsetheseexpressionstocalculatevaluesforThematicMapping,UpdateColumn,
andLabelWithColumninLayerSettings.
ConstructingSimpleExpressions
Youformulateexpressionsusingcolumn(field)namesandconstants(forexample,specificdatavalues),
ontheonehand,andfunctionsandoperators,ontheother.Thinkofthecolumnnamesandconstants
asnouns,andfunctionsandoperatorsasverbs,prepositionsandconjunctions.Youalwaysneedat
leastonecolumnnameoraconstantinanexpression.Howmanyoperatorsandfunctionsyouneed
dependsonwhatyouwanttodowithyourexpression.
Thesimplestpossibleexpressionconsistsofacolumnname,forexample:
1. POP_1990
2. STATE
YoucouldusesuchanexpressioninThematicMappingtoindicatewhatdataistoberepresentedon
themap.InUpdateColumnsuchanexpressionwouldtellMapInfoProfessionalwhatdatatousein
updatingacolumninthetargettable.
Herearesomeslightlymorecomplexexpressions:
1. POP_1990>17893
2. POP_1990<=POP_1980
3. COUNTY<>"Orange"
4. POP_1980*1.2
5. POP_1990/TOTAL_AREA
6. round(POP_1990/TOTAL_AREA,.1)
Thefirstthreeexamplesusecomparisonoperators.Thefirstteststoseewhetherthe1990population
isgreaterthan(>)someconstant(17893).Thesecondteststoseewhetherthevalueofonecolumn,
POP_1990,islessthanorequalto(<=)thevalueofanothercolumn,POP_1980.Thethirdteststosee
whetherornotthecountyisOrange.Whenthecountydoesnotequal(<>)"Orange"therecordis
selected.YoucoulduseanyoftheseexpressionsinSelectorintheWhereConditionclauseofSQL
Select.Thesecommandsallowyoutoselectasubsetoftherecordsinatable.Theexpressiondefines
thecharacteristicsofthesubset.
Examples6and7usearithmeticoperators.Example6multiplies(*)thevalueofPOP_1980byaconstant
(1.2)whileexample7dividesonecolumn,POP_1990,bythevalueofanothercolumn,AREA.
Example8usestheroundfunctiontoroundthevalueoftheexpression"POP_1990/TOTAL_AREA"to
thenearesttenth(.1).
Expressions6,7and8donothavecomparisonoperatorsandthereforetheywouldnotbesuitablefor
useinSelectorintheWhereConditionclauseofSQLSelect.However,youcouldusethemalonein
ThematicMapping,UpdateColumn,orSelectcolumnsinSQLSelect.
SettingFilterCriteriaforExpressions
Afiltercriterionisalogicalexpressionthatusuallycomparesacolumnvalueagainstsomeothervalue.
Forexample,thefollowingfiltercriterionusesthegreater-thanoperator(>)totestwhetherthe
Order_Amountcolumnhasavaluegreaterthanonehundred:
Where Condition: : Order_Amount > > 100
IfaqueryincludestheprecedingWhereConditionclause,MapInfoProfessionalselectsonlytherows
thathaveanOrder_Amountvaluegreaterthanonehundred.
TheWhereConditionfieldcancontaintwoormorelogicalexpressionsiftheexpressionsareseparated
bythewordAndorbythewordOr.IftheexpressionsarejoinedbythewordAnd,MapInfoProfessional
onlyselectstherowsthatsatisfybothcriteria.IftheexpressionsarejoinedbythewordOr,MapInfo
Professionalselectsanyrowthatsatisfieseithercriterion.
MapInfoProfessional12.5
438
CreatingExpressions
Filtercriteriacanuseanycolumninyourbasetable(s),regardlessofwhetheryouincludedthecolumn
intheSelectColumnsfield.
Columnscanbereferredtobynameorbynumber,wherethenumberdesignatestheorderthecolumn
hasinSelectColumns.Thus,"col1"and"col6"refertothefirstandsixthcolumns,respectively.The
numbermustbeprecededbytheletters"col".
• Formoreinstructionsandrelatedtopics,seetheUsingExpressionstoCreateaNewColumntopicin
theHelpSystem.
ConstructingComplexExpressions
Nowconsiderexamples9and10,thatareabitmorecomplexthan1through8:
1. POP_1990>POP_1980*1.2
2. round((POP_1980*1.2)/TOTAL_AREA,.1)
Wecreatedexpression9bytakingexpression3andreplacingtheconstant"17893"withthewholeof
expression6.Similarly,wecreatedexpression10bytakingexpression8andreplacing"POP_1990"
withexpression6.
Ingeneral,youcreatecomplexexpressionsbycombiningsimpleexpressions.Perhapsthebestwayto
learnhowtodothisislookatsomeoftheexampleswehaveprovided(aboveandfollowing)andcreate
yourownexpressionsbasedonthoseexamples.However,therearetwoverygeneraltechniquesfor
creatingcomplexexpressions.
• Replaceacolumnnameoraspecificvaluewithasimpleexpression.
• Combineexpressionsusinglogicaloperators(and,not,or).
Examplesixillustratesthefirsttechnique.Therearemanyexamplesofthesecondtechniquethroughout
thisentry.SeeparticularlythediscussionfollowingUsingLogicalOperatorsinExpressions.
EnteringSpecificValues(Constants)intoExpressions
UsetheExpressiondialogboxtoformulatemathematicalandalphanumericexpressionsinseveral
MapInfoProfessionaldialogboxes.
Whenenteringspecificcharacterstrings,numbers,anddatesintoexpressions,youneedtoobserve
thefollowingconventions.
CharacterStringsinExpressions
Whentypingaparticularstringintoanexpressionyoumustencloseitindoublequotes.MapInfo
Professionalthentreatsitasastringratherthanasacolumnname.Forexample,strings1and2shown
belowarevalidstringconstants,while3and4arenot.
1. "Orange"
2. "NewYork"
3. Orange
4. NewYork
NumbersinExpressions
Whenenteringspecificnumericalvalues,donotusecommas,dollarsigns,oranycharactersotherthan
numerals,decimalpoints,andtheminussignfornegativenumbers.YoucanuseEtodenotenumbers
inexponentiation.
DateValuesinExpressions
Datesconsistofamonth,aday,andanoptionalyear.Theyearisspecifiedbytwoorfourdigitsand
enclosedindoublequotes.Thecomponentsofadateareseparatedbyhyphensorslashes.Iftheyear
isnotspecified,itdefaultstotheyearsetonyourcomputer'sclock.Thefollowingarevaliddataconstants:
439
MapInfoProfessionalUserGuide
Chapter17:SpecializedTopicsinMapInfoProfessional
WhatMapInfoProfessionalExpects
SystemOrder
02/28/2005
M/d/yy
02/28/2005
M/d/yyyy
02/28/2005
MM/dd/yy
02/28/2005
MM/dd/yyyy
2005/02/28
yy/MM/dd
02-28-2005
dd-MMM-yy
UsingMathematicalOperatorsinExpressions
UsetheExpressiondialogboxtoformulatemathematicalandalphanumericexpressionsinseveral
MapInfoProfessionaldialogboxes.Mathematicaloperatorsareoftenusedincreatingexpressions.The
followingchartshowstheoperator'ssymbol,name,example,andhowtheoperatorshandledifferent
datatypes.
DetailedExample
Example
Description
Symbol
Date+Number:Date
04/01/2007+4:04/05/2007
A+B
plus
+
FloatNumber+Date:Date
4+232:236
Date-Number:Date
Number-Date:Date
A-B(subtraction)
-A(negative)
minus
-
236-4:232
somenumber-somenumber:Float
someinteger*someinteger:Integer
somenumber*somenumber:Float
A*B
times
*
somenumber/somenumber:Float
A/B
dividedby
/
somenumber^somenumber:Float
A^B
exponentiation
^
Thefollowingcalculationsarepossible:
• Addingnumberstodatestoyieldanotherdate.
• Subtractinganumberfromadatetoyieldanotherdate.
• Subtractingadatefromadatetoyieldanumber.
Whenyouaddnumberstodatesorsubtractnumbersfromdates,MapInfoProfessionaltreatsthenumbers
asspecifyinganumberofdays.Whenyouaddorsubtractaweek,youusethenumber7.
Whenyouaddorsubtractamonth,youuse30or31.WhenMapInfoProfessionalsubtractsadatefrom
adate,theresultindicatesanumberofdays.
UsingStringOperatorsinExpressions
"concatenation"-connectsstringsandstringexpressions.
+
MapInfoProfessional12.5
440
CreatingExpressions
Documents you may be interested
Documents you may be interested