pdf reader c# : Acrobat delete text in pdf control application platform web page html azure web browser MapInfoProfessionalUserGuide24-part757

ExpandingthetextcontrolsisnoguaranteethattheresultingquerycanbehandledbyMapInfo
Professional.YoucanstillreceivetheQuerytoocomplexerrorwhenaddinglargerqueries.
Note:
Example1-ComputingPopulationDensityUsingArea
Inthisexample,wewillusetheworldmaptocreateatableofallthecountriesthathaveapopulation
densityofover500peoplepersquaremile.
Thefollowingformulacomputespopulationdensity:
• POPULATION/AREA
WhiletheWORLDtablehasapopulationcolumn(pop_1994),itdoesnotincludeacolumnforcountry
area.However,sincetheWORLDtablehasgraphicobjectsassociatedwiththerecords,MapInfo
Professionalcancomputethetotalareaforeachcountry.
OpentheWORLD.TABtable,andmaximizeitsdisplaybyclickingthewindow'smaximizebutton.On
theQuerymenu,clickSQLSelecttodisplaytheSQLSelectdialogbox.
TocompletetheSQLSelectdialogbox:
1. IntheFromTablesbox,chooseWORLDfromtheTablesdrop-downlist.
YoucanspecifymorethanonetableinanSQLstatement.Thisexampleusesonlyonetable,WORLD.
YoushouldfillintheFromTablesboxbeforeyoufillintheSelectColumnsbox.MapInfoProfessional
usesthetablesintheFromTablesboxtogeneratethelistofcolumnsintheColumnsdrop-down
list.
2. PlaceyourcursorintheSelectColumnsboxanddeletetheasterisk(*).Inthisexample,wewill
specifyalistofcolumnstobeincludedintheresultingquerytable,insteadofincludingallcolumns.
Anasterisk(*)intheSelectColumnsboxmeansbydefaultthatallcolumnswouldbequeried.
Note:
Remember,thequerytableisthetemporarytablethatMapInfoProfessionalcreatestostorethe
resultsofthequery.
3. SelectCountryfromtheColumnsdrop-downlist.
4. Selectpop_1994fromtheColumnsdrop-downlist.
Now,weneedtocomputepopulationdensity.Remember,populationdensityiscomputedbydividing
populationbyarea.ThereisnoAreacolumninthetable.However,thereisafunction,Area,which
willcomputetheareaofanymappableobject.SincetheWORLDtableismappable,MapInfo
Professionalcancomputetheareaofeachcountryand,therefore,thepopulationdensityofeach
country.
5. Selectthedivisionsign(/)fromtheOperatorslist.
6. SelectAreafromtheFunctionspopup.
Thiscreatesaderivedcolumn.Aderivedcolumnisacolumnthatcontainstheresultsofcalculations
performedonanothercolumnorcolumns.WhenMapInfoProfessionalcreatesthequerytable,itwill
includetwocolumns:theCountrycolumnandthepop_1994/Area(obj,"sqmi")column,whichis
ourpopulationdensitycolumn.MapInfoProfessionalincludesaunitsstatementwithallgeographic
functions.IfyouwantedMapInfoProfessionaltoreturntheareainsquarekilometers,youwould
change"sqmi"to"sqkm."
Now,weneedtobuildanexpressionthatselectsonlythosecountrieswhosepopulationdensityis
over500peoplepersquaremile.
7. TabtotheWhereConditionboxandselectpop_1994fromtheColumnsdrop-downlist.
8. Selectthedivisionsign(/)fromtheOperatorsdrop-downlist.
9. SelectAreafromtheFunctionspopup.
10.Selectthegreaterthansign(>)fromtheOperatorsdrop-downlist.
11.Typethenumber500.
241
MapInfoProfessionalUserGuide
Chapter9:SelectingandQueryingData
Acrobat delete text in pdf - 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
delete text from pdf online; erase text from pdf file
Acrobat delete text in pdf - 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
pdf editor delete text; how to erase in pdf text
Wehavenowbuilttheexpression"Selectallcountrieswhosepopulationdensity(pop_1994/Area(obj,
"sqmi"))ismorethan(>)500peoplepersquaremile."
12.LeavetheGroupbyColumnsboxblank.
13.TabtotheOrderbyColumnsboxandselectCountryfromtheColumnslist.
TheOrderbyColumnsboxallowsyoutospecifytheordertherecordsinthequerytablewilldisplay.
ByselectingCountry,MapInfoProfessionalwilllisttherecordsinalphabeticalorder,accordingto
countryname.
14.TabtotheIntoTableNamedboxandtypeDENSITY.
Bydefault,MapInfoProfessionalnamesthequerytableQuery1.Subsequentquerytableswillbe
namedQuery2,Query3,andsoon.Youcanchangethenameofthequerytablebytypinginanew
tablenameintheIntoTableNamedbox.MapInfoProfessionalwillnamethequerytableDENSITY.
15.ClickVerify.MapInfoProfessionalchecksthesyntaxofyourSQLstatement.Ifthereareanyerrors
inyourstatement,MapInfoProfessionalgivesyouanerrormessagetellingyouwhattheerrorisand
whichboxcontainstheerror.
16.SelecttheBrowseResultscheckboxtocreateaBrowserofthequerytable.Ifyoudonotselect
BrowseResults,MapInfoProfessionalstillcreatesthetemporaryquerytablebutdoesnotdisplay
it.Ifyouwantedtodisplaythetableafterthefact,choosetheBrowseoptionintheWindowmenu
andselectDENSITYfromthedrop-downlist.
17.TodisplaythequeryresultsinthecurrentlyactiveMapwindow,selectFindResultsinCurrentMap
Window.IftherearenoopenMapwindows,thischeckboxisdisabled.Youcannotsavethischeck
boxsettingtoatemplate.Thisoptionisclearedbydefault.
MapInfoProfessional12.5
242
QueryingYourDatainMapInfoProfessional
.NET PDF Document Viewing, Annotation, Conversion & Processing
Redact text content, images, whole pages from PDF file. Edit, update, delete PDF annotations from PDF file. Print. Support for all the print modes in Acrobat PDF
how to delete text from a pdf in acrobat; how to copy text out of a pdf
C# PDF Converter Library SDK to convert PDF to other file formats
independently, without using other external third-party dependencies like Adobe Acrobat. If you need to get text content from PDF file, this C# PDF to
how to erase pdf text; remove text from pdf
18.ClickOKtocreatethefollowingtable.
Thefirstcolumncontainsthecountryname.Thesecondcolumncontainsthepopulationdensity.
Notethatthecountriesarelistedinalphabeticalorder(OrderBy:Country)andthepopulationdensity
foreachcountrylistedisover500peoplepersquaremile(pop_1994/Area(obj,"sqmi")>500).
Example2-ComputingPopulationDensitywithSQL
TosetupanSQLSelectstatementthatselectsonlythosestateswithahighpopulationdensity,dothe
following:
1. OntheFilemenu,clickOpenTableandopentheSTATEStableinaMapwindow.
2. OntheQuerymenu,clickSQLSelectandfillintheSQLSelectdialogbox.
• SelectColumns:*
• fromTables:States
• whereCondition:(Pop_1990 / Total_Area) > 500
• intoTableNamed:HIDENSITY
Thiscreatesanewtable,HIDENSTY,thatcontainsonlythosestateswitharelativelyhighpopulation
density(populationdividedbytotalarea).Theasterisk(*)intheSelectColumnsboxtransfersallof
thecolumnsintheSTATEStabletotheHIDENSTYtable.
3. OntheFilemenu,clickSaveCopyAsandsavetheSelectiontable.Thetablecanbesavedwith
anyfilename.
TheHelpSystemcontainstheserelatedtopics:
• ExamplesofGroupbyColumns
• Example-UsingtheGroupbyColumnsFieldtoSubtotaltheResultsTable
• Example-UsingtheOrderbyColumnsFieldtoSorttheResultsTable
SavingQueries
AnyquerycreatedusingtheSelectorSQLSelectcommandscanbesavedasaMapInfoProfessional
querytable.Querytablesconsistofa.tabfileanda.QRYfile.AfteryouhaveexecutedaSelectorSQL
Selectstatement,ontheFilemenu,clickSaveQuerytosavethequeryasatable.Whenyouopenthis
table,thetablesonwhichthequeryisbasedarere-openedandthequeryisre-executed.
Queriesmadeagainstotherqueriescannotbesavedasatableorinaworkspace.
Note:
SavingQueriestoWorkspaces
Youcanalsosavequeriesinworkspaces.Whenyouopenaworkspacethatcontainsaquery,thequery
willexecuteandanywindowscreatedbythequerywillredisplay.Unlikesavingaqueryasatable,a
separate.tabfileisnotcreatedwhenyousaveaquerytoaworkspace.
Tosavequeriestoaworkspace,theSaveQueriesinWorkspacescheckboxmustbeselected
intheStartuppreferences.MapInfoProfessionalselectsthischeckboxbydefault.
Note:
ActivatingSaveQuerywhenUsingaWorkspace
ToactivatetheSaveQueryoptionwhenusingaworkspace,youmustactivatetheSaveQueriesin
WorkspacesoptionintheStartupPreferencesdialogbox.
1. ChooseOptions>Preferences>Startup.TheStartupPreferencesdialogboxdisplays.
2. ChecktheSaveQueriesinWorkspacesoption(defaultsetting).
3. ClickOK.
Ifyouselectedthisoptionandopenaworkspace,theassociatedqueriesareregenerated.Aseparate
MapInfoProfessionaltable(.tab)fileforthequeriesisnotcreated.
OnlyqueriescreatedusingtheSQLSelectorSelectcommandsaresavedinaworkspace.
Note:
243
MapInfoProfessionalUserGuide
Chapter9:SelectingandQueryingData
C# powerpoint - PowerPoint Conversion & Rendering in C#.NET
documents in .NET class applications independently, without using other external third-party dependencies like Adobe Acrobat. PowerPoint to PDF Conversion.
delete text pdf document; how to edit and delete text in pdf file
C# Word - Word Conversion in C#.NET
Word documents in .NET class applications independently, without using other external third-party dependencies like Adobe Acrobat. Word to PDF Conversion.
how to delete text in pdf file; how to erase text in pdf online
UsingDate-andTime-BasedDatainMapsandQueries
Ifyoumaintaintime-ordate/time-specificdata,youmaybeinterestedinqueryingthatinformationand
displayingitvisuallyinyourmaps.TimeandDateTimedatatypesletyoudisplaythatdatathematically
andaspartofaqueryanalysis.Youcouldusethisdatatypeformanytypesofprojects,suchasto
displaycrimeinformationbasedonDateandTimeortopostschedulesbasedonresourceavailability
onaparticulardate.Also,youcanuseusethedateandtimedatafromAccess,Excel,dBase,and
remotedatabases.
TimeandDateTimedatatypesoptionsaremadeavailableinthelistsofyourQuerydialogboxes.
UsingTimeandTime/DateDataTypes
Youcanconvertexistingfieldswithtimeortime/dateinformationintoTimeandTime/Dateformats,so
youcanusethemforqueryingandthematicmaps.
Toconvertyourdata:
1. OpenthedatayouwanttoconvertinMapInfoProfessional.
2. ChoseTable>Maintenance>TableStructureandselectthetableforwhichyouwanttochange
thedatatype.TheModifyTableStructuredialogboxdisplays.
3. TochangetheArrivalTimefieldfromacharacterfieldtoaTimefield,clicktheTypedrop-down
arrowandselecttheTimetype.
4. ClickOKtosaveyourchange.
AddingTimeorDateTimeDataTypestoExistingData
MapInfoProfessional12.5
244
QueryingYourDatainMapInfoProfessional
VB.NET PDF: How to Create Watermark on PDF Document within
create a watermark that consists of text or image (such And with our PDF Watermark Creator, users need no external application plugin, like Adobe Acrobat.
delete text from pdf with acrobat; delete text from pdf file
C# Windows Viewer - Image and Document Conversion & Rendering in
standard image and document in .NET class applications independently, without using other external third-party dependencies like Adobe Acrobat. Convert to PDF.
delete text pdf file; remove text from pdf online
IfyouhaveexistingdataandwanttoaddTimeorDateTimecontenttoit,checkthefollowingtableto
ensurethatthedataisinaformatthatMapInfoProfessionalcanrecognizeasTimeorDateTime.
Table1:TimeandDateTimeDataFormats
ToFormatforDateTime
ToFormatforTime
Enter
yyyyMMdd
NotApplicable.
Date
SetsvaluetothespecifiedDateat
midnight.
HHmmssfff
HHmmssfff.
Time
Setsvaluetocurrentdateatspecified
Time.Canalsousethelocalesettings
Canalsousethelocalesettingsfora
Timestring.
forDateandTimestringsseparatedby
aspace.
yyyyMMddHHmmssfff
yyyyMMddHHmmssfff
DateTime
SetsvaluetoTimeportionofDateTime
value.
where:
HHreferstohours,mmreferstominutes,ssreferstoseconds,ffreferstofractionsofseconds,yyyy
referstoyears,MMreferstomonth,ddreferstodate
ConvertingExistingDatatoTimeorDateTimeDataTypes
IfyouhaveTimeorDateTimedatainyourtablesalready,checktoseeifitisintheformatyouwantby
checkingtheTimeandDateTimeDataFormats.Ifyouhavealotofdataanditisnotintheformatyou
requireforyourtasks,youcanuseoneoftheMapBasicconversionfunctionstoassistyouwiththis
process.
DateTime
Time
Date
Converting
Stringcanbeintheform
yyyyMMddHHmmssffforcan
Stringcanbeintheform
HHmmssffforcanusethe
Assumestheform
yyyyMMddorlocalesettings
String
usethelocalesettingsfor
localesettingsforaTime
string.**
foradatestringifDate
formatis"local"ortheU.S.
formifDateformatis"US".
*
DateandTimestrings
separatedbyaspace.***
Assumestheform
yyyyMMddHHmmssfff.Ifany
Assumestheform
HHmmssfff.Ifanyportionof
Assumestheform
yyyyMMdd.Ifanyportionof
Number
portionoftheDateTimeis
theTimeisinvalidthevalue
theDateisinvalidthevalue
invalidthevalueissettonull
issettonullanddisplaythis
issettonull.Maydisplay
anddisplaythiserror:"Could
notconvertdata."
error:"Couldnotconvert
data."
thiserror:"Couldnotconvert
data."
Setsvaluetothespecified
Dateatmidnight.
Setsvaluetonulland
displaythiserror:"Couldnot
convertdata."
Noconversion
Date
Setsvaluetocurrentdateat
specifiedTime.
Noconversion
Setsvaluetonull.May
displaythiserror:"Couldnot
convertdata."
Time
245
MapInfoProfessionalUserGuide
Chapter9:SelectingandQueryingData
C# Excel - Excel Conversion & Rendering in C#.NET
Excel documents in .NET class applications independently, without using other external third-party dependencies like Adobe Acrobat. Excel to PDF Conversion.
remove text from pdf preview; delete text from pdf
VB.NET PowerPoint: VB Code to Draw and Create Annotation on PPT
other documents are compatible, including PDF, TIFF, MS free hand, free hand line, rectangle, text, hotspot, hotspot more plug-ins needed like Acrobat or Adobe
how to remove text watermark from pdf; remove text from pdf
DateTime
Time
Date
Converting
Noconversion
SetsvaluetoTimeportion
ofDateTimevalue.
SetsvaluetoDateportionof
DateTimevalue.
DateTime
AdditionalNotesforConvertingaString
*toaDate
IftheyearislastinthecurrentDateformat,youcanomititandMapInfoProfessionalwillassumethe
currentyear.Ifthedataspecifiesatwo-digityear,MapInfoProfessionalassignsthecenturybasedon
thecurrentDateWindow.IftheDateisinvalidthevalueissettonullandMapInfoProfessionalmay
displaytheerror,"Couldnotconvertdata."
**toaTime
MapInfoProfessionalacceptsbothmilitaryandAM/PMforms.Thedatacanspecifytheentirelocalein
AMorPMstringsorusejustthefirstcharacterofeach.Thedatamayomitthemilliseconds,seconds,
andminutesifthelower-orderportionsarealsoomitted.IftheTimeisinvalidthevalueissettonulland
MapInfoProfessionalmaydisplaytheerror,"Couldnotconvertdata."
***toaDateTime
TheconversionrulesforDateandTimeapplyfortherespectiveportionsofthestring.Ifthedataomits
theTimeportion,MapInfoProfessionalassumesmidnight.IftheDateTimeisinvalidthevalueissetto
nullandMapInfoProfessionalmaydisplaytheerror,"Couldnotconvertdata."
AdditionalNotesforConvertingaNumbertoaString
#TheconversionrulesforDateandTimeapplyfortherespectiveportionsofthestring.Ifthedataomits
theTimeportionMapInfoProfessionalassumestheTimeismidnight.IftheDateTimeisinvalidthevalue
issettonullandMapInfoProfessionalmaydisplaytheerror,"Couldnotconvertdata.".
Ifyouhavealotofdataanditisnotintheformatyourequireforyourtasks,youcanuseoneofthe
MapBasicconversionfunctionstoassistyouwiththisprocess.
CreatingaDateTimeColumnfromTwoSeparateColumns
TocreateaDateTimecolumnfromaDatecolumnandaTimecolumn:
1. OpenyourdatainMapInfoProfessionalBrowserwindow.WeuseCrimeActivity.TABfromthe
IntroductoryDataonyourDVD.
2. ChooseTable>Maintenance>TableStructuretodisplaytheModifyTableStructuredialogbox.
3. ClickAddFieldandtypeaDate_TimelabelintheNamefield.
4. SelectDate/TimeintheTypedrop-downlistandclickOK.
5. SelectTable>UpdateColumntodisplaytheUpdateColumndialogbox.
6. SelectthetablenameintheTabletoUpdatedrop-downlist.
7. SelectthenameofthenewcolumnyoujustcreatedintheColumntoUpdatedrop-downlist.
8. SelectthetablenameagainintheGetValuefromTabledrop-downlist.
9. ClicktheAssistbuttontodisplaytheExpressionsdialogbox.
10.UsetheColumndrop-downlisttocreatethefollowingexpressionandclickOK:
DateColumnName + TimeColumnName
MapInfoProfessional12.5
246
QueryingYourDatainMapInfoProfessional
FormoreaboutusingmathexpressionswithTimeandDateinformation,seeUsingArithmeticOperators
withTimeandTime/DateDataTypes.
1. ClickOKtoupdatethenewcolumnwiththeDateandTimeinformation.
CreatingThematicMapsusingTimeandTime/DateDataTypes
Forrangedthematicmaps,Timevalueswillbeabletoberoundedbyseconds,minutes,andhours.The
defaultisseconds.WhenyouselectNone,MapInfoProfessionaldoesnotroundtheelectingtheseconds
anddisplaysagranularityofmilliseconds.
Ifyourdataisonaremotedatabase,youmaybeinterestedintheTimeandDateTimeData
TypeSupportforRemoteDatabasesintheHelpSystem.
Note:
TocreateathematicmapusingDateTimeinformation:
1. OpenyourdatainMapInfoProfessionalBrowserwindow.Usetheappropriatebackgroundmapto
giveyourdataperspective.HereweusetheGreatBritaindataintheIntroductoryDataontheMapInfo
ProfessionalDVD.
2. ChooseQuery>SQLSelecttodisplaytheSQLSelectdialogbox.
3. PlaceyourcursorinthefromTablesfieldandselectthetablenamethatcontainstheDateTime
datainthefromTablesdrop-downlist.ForourexampleweusedtheCrimeActivitytable.
4. TofindoutthelocationofcrimesbetweenApril10,2003andApril10,2004andbetweenthehours
of12and8p.m.,weenteredthistextinthewhereConditionbox:
Crime_Date between "04/10/2003" and "04/10/2004" And Crime_Time between
"12:00:00 PM" and "08:00:00 PM"
1. SelecttheBrowseResultsandFindResultsinCurrentMapWindowcheckboxestodisplaythe
results.
2. ClickOKtocreatethequeryanddisplaytheresults.
247
MapInfoProfessionalUserGuide
Chapter9:SelectingandQueryingData
UsingArithmeticOperatorswithTimeandTime/DateDataTypes
YoucanusetheadditionandsubtractionoperatorswiththeTimeandTime/Datedatatypesasfollows:
Notes
Result
Datatype
Operator
Datatype
Thenumberrepresentsthe
numberofsecondsbetweentwo
Number
Time
minus(-)
Time
timesasafloatingpointnumber.
Thefractionalpartoftheresult
representsmilliseconds.
Thenumberrepresentsthe
secondstoaddtothefirstTime.
Time
Number
+or-
Time
TheTimewrapsaroundmidnight
sothat11:59PM+120seconds
equals12:01AM.
Thenumberrepresentsthe
numberofdaysbetweentwo
Number
DateTime
minus(-)
DateTime
DateTimesasafloatingpoint
number.Thefractionalpartofthe
resultisthefractionalportionof
aday,asintodayatnoonminus
todayatmidnightequalsonehalf
day.
Thenumberrepresentsthe
numberofdaystoaddtothefirst
Time.
DateTime
Number
+or-
DateTime
UsingComparisonOperatorswithTimeandTime/DateDataTypes
MapInfoProfessional12.5
248
QueryingYourDatainMapInfoProfessional
Thecomparisonoperatorsare=,<>,<,>,<=,>=andshouldallworkasexpectedfortheTimeand
DateTimevalues.ForTimevalues,thesmallestTimeis"12:00:00.000AM"whilethelargestTimeis
"11:59:59.999PM".
The"Between"operatorworksasexpectedforDateTimevalues.ForTimevalues,wesupportwrap-around
comparisons.Forexample:
TimeValueBetween"2:00AM"And"10:00PM"istrueiftheTimeValueisgreaterthanorequalto"2:00
AM"andlessthanorequalto"10:00PM"
TimeValueBetween"10:00PM"And"2:00AM"istrueiftheTimeValueisgreaterthanorequalto"10:00
PM"andlessthanorequalto"11:59:59.999"orgreaterthanorequalto"12:00AM"andlessthanor
equalto"2:00AM"
UsingLogicalOperatorswithTimeandTime/DateDataTypes
ATimeorDateTimefieldwithavalueistrue,whilethesamefieldwithanullvalueindicatesfalse.The
behaviorofthelogicaloperatorsAnd,Or,andNotshouldfollowlogicallyfromthis.
InterpretingExcelData
UsingExcelyoucanformatnumericcellsasDatesand/orTimes.Exceldeterminesthemeaningofthe
'm'formatcodeaseither'month'or'minute'basedontherestoftheformatcode.
Aretreatedas
Fieldsregisteredwith
Datefields
DateformatbutnotTimeformat
Timefields
TimeformatbutnotDateformat
DateTimefields
DateformatandTimeformat
TheDatefieldsinolderMapInfoProfessionalfilesaretreatedasDatefieldsuntilyoure-register
themtousetheDateTimedatatype.OlderversionsofMapInfoProfessionalsupportedDate
Note:
fieldswiththeformat'y'(year),'m'(month),or'd'(day).Timefieldswithintheformat'h'(hour)or
's'(second)weretreatedasFloatfields.FieldswithDateandTimeformatcodesweretreated
asaDatefieldandtheTimeinformationwasignored.
TheHelpSystemcontainstheserelatedtopics:
• EnsuringthatDatesDisplayCorrectlyforExcelforMacintoshTables
• ControllinghowMapInfoProfessionalHandlesMixedDataTypeColumns
InterpretingMicrosoftAccessData
AccessdatausesaDateTimetype,butnotseparateDateorTimetypes.MapInfoProfessionalregisters
theAccessDateTimetypefieldsasDateTimefields.
TheDatefieldsinolderMapInfoProfessionalfilesaretreatedasDatefieldsuntilyoure-register
themtousetheDateTimedatatype.
Note:
WhenyousaveaMapInfotabletoAccessformat,MapInfoProfessionalwritesDate,Time,andDateTime
fieldsasAccessDateTimefields.The.tabfileitselfmaintainstheDate,Time,andDateTimetypesso
whenyoureopenthefile,theDate,Time,orDateTimedatadisplays.Ifyouattempttoopenthese.tab
filesusinganon-MapInfoapplication,thesefieldsdisplayasDateTime.
InterpretingdBaseData
ThedBaseformatsupportsDatefieldsbutdoesnotexplicitlysupportTimeorDateTimefields.Therefore,
whenyouregisteranexistingdBasefile,therewillbenoTimeorDateTimefields.Whenyousaveor
exportaMapInfotablewithTimeorDateTimefieldstoadBasefile,TimeandDateTimefieldsarewritten
outascharacterfieldsoflength9and17,respectivelysothatthedataiswrittenoutinnumericformats.
249
MapInfoProfessionalUserGuide
Chapter9:SelectingandQueryingData
WhenyousaveaMapInfotabletodBaseformat,the.tabfilemaintainstheTimeandDateTimetypes
sothatwhenyoureopenitthedatadisplaysaseitherTimeorDateTime.Ifyouattempttoopenthese
.tabfilesusinganon-MapInfoapplication,thesefieldsdisplayascharacterfields.
TheHelpSystemcontainstheserelatedtopics:
• TimeandDateTimeDataTypeSupportforRemoteDatabases
• InterpretingASCIIandCSVData
UsingTemplatesforQueries
QuerytemplatesenableyoutosaveSelectorSQLSelectstatementsastemplatesandreloadthem.
Thissavesyouthetroubleofhavingtorebuildaqueryeachtimeyouwanttouseit.BoththeSelect
andSQLSelectdialogboxeshaveLoadTemplateandSaveTemplateoptionstoenableyoutodothis
easily.Querytemplatesareusefulforre-creatingaquerywithanupdatedversionofthetableusedin
theoriginalquery,orforexecutingaqueryonatablethathasthesamefieldsasthetableonwhichthe
querystatementwascreated.
LoadingaTemplate
Youcanloadanysavedquerytemplate.
Toloadaquerytemplate:
1. IntheSelectorSQLSelectdialogboxes,licktheLoadTemplatebutton.TheLoadDialogFrom
QueryFiledialogboxdisplays.Itliststhe.QRYfiles.
2. Selectthe.QRYfileyouwanttouse,andclickOpen.TheSelectorSQLSelectdialogboxdisplays
withthevaluesfromthetemplatealreadyfilledin.Simplyexecuteyourquerytocreatethequery
browser.
RenamingaTemplate
Renameatemplatebyselectingandclickingthetemplatename;enteranewnameupto64characters.
SavingaTemplate
AfteryouhavefinishedwritingyourSelectorSQLSelectquery,youcansavethequeryasatemplate.
Tosaveaqueryasatemplate:
1. IntheSelectorSQLSelectdialogboxes,clicktheSaveTemplatebuttontosavethequerytoa
template,orqueryfile.TheSaveDialogtoQueryFiledialogboxdisplays.
2. Givethequeryfileaname,selectafolder,andclickSave.Queryfilesaresavedwitha.QRYextension
andaresavedinthedirectoryspecifiedintheDirectoriespreferences.
Thequerydoesnotneedtobecompleteorsyntacticallycorrecttosaveittoatemplate.
Note:
DeletingaTemplate
Todeleteatemplate:
• SelectthetemplatenameandpresstheDelete
key.Adialogboxdisplayspromptingyoutoconfirm
orcanceltheoperation.Ifnotemplatesofthegiventypeexist,abuttontorestoreadefaulttemplate
displays.
DerivingColumns
Aderivedcolumnisacolumninaquerytablewhosecontentsarecreatedbyapplyinganexpression
tothevaluesofcolumnsalreadyexistinginsomebasetable.Intheexampleabove,populationdensity
wasaderivedcolumn.Bydefault,theSelectColumnsboxcontainsanasterisk(*),indicatingthatall
ofthecolumnsinthebasetablearetobeincludedinthequerytable.Ifyoudonotwantallofthose
columns,youshoulddeletetheasteriskandlistonlythosecolumnsthatyouwanttouse.Youarenot
MapInfoProfessional12.5
250
QueryingYourDatainMapInfoProfessional
Documents you may be interested
Documents you may be interested