pdf reader c# : How to delete text in pdf document control Library system azure .net asp.net console MapInfoProfessionalUserGuide18-part750

MakingaDBMSTableMappabletoDisplayitona
Map
AfterestablishingadatasourceconnectiontoyourDBMSandaddingageometryreferencetothetables
youwishtoworkwith,youcanbeginworkingwiththedatainMapInfoProfessionalintabularform(ina
Browserwindow).ToviewthedataonamapinMapInfoProfessional,youmustcorrectlynamethe
spatialdatagoemetryorX,Ycolumnsandthenmakethetablemappable.
Beforemakingatablemappable,reviewtheinstructionsunderCreatingaMapCatalogintheDBMS
toWorkwithDataandAddingaSpatialPrimaryKeytoaDBMSTable.
MapInfoProfessional'sMakeTableMappablemenuoptionmakesadatabasetable(DBMStable)
viewableonaMapwindowinMapInfoProfessional.AnytablemaydisplayinaBrowserwindow,but
onlymappabletablescandisplayinaMapwindow.
MakingatablemappableprovidesMapInfoProfessionalwithinformationaboutthetable:
• Thecolumncontainingthespatialdata(notapplicabletorelationalOracleSDO)
• Theprojectionsystemofthetable
• Thesymboltouseforallobjectswithoutaperrowstyle
• Thecolumninthetabletouseforperrowstyles
• Theobjecttype
• Thetablebounds,whichinformsMapInfoProfessionaloftheentireextentofthedata(usedbyView
andEntireLayerforexample)
MapInfoProfessionaltakesthisinformationandstoresitinatablecalledtheMapInfo_MapCatalog.
EverytimeyouuseaDBMStableMapInfoProfessionalchecksthecatalogtoseeifthetableismappable.
Asaresult,youonlyhavetomakeaDBMStablemappableonce.Itwillalwaysremainmappable.
MakingaTableMappable
UsetheMakeTableMappablemenuoptiononlyfortablesthatyoudidnotpreviouslyuploadwith
EasyLoader,orsavetothedatabasethroughMapInfoProfessional.
Beforeyoubegin,youmusthaveadatasourceconnecttothedatabasecontainingthetabletomap.
Forinstructions,seeCreatingaDataSourceConnection.
Tomakeatablemappable:
1. FromtheTablemenu,selectMaintenance>MakeDBMSTableMappable.
2. IntheSelectDBMSTabledialogbox,selecttheDBMStableyouwanttomakemappableandclick
Open.
3. IntheMakeTableMappabledialogbox,selectfromtheoptionsandthenclickOKtomakethetable
mappable.Foroptiondescriptions,seeMakeTableMappabledialogboxOptions.
4. Amessagedialogdisplaystotellyouthatthetablehasbeenmademappable.ClickOK.
5. TheSelectDBMSTabledialogdisplays.SelectthetabletomakemappableandclickOpen.Click
Cancelifyoudonotwanttomaketablesmappable.
Aftermakingatablemappable,youarereadytobeginworkingwithitinMapInfoProfessional.Continue
to:
• WorkingwithSQLServerTables
• WorkingwithPostGISTables
• WorkingwithOracleSpatialTables
MakeTableMappabledialogboxOptions
181
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
How to delete text in pdf document - 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
acrobat remove text from pdf; how to edit and delete text in pdf file online
How to delete text in pdf document - 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
erase text from pdf file; how to delete text from a pdf in acrobat
IndexType
SelectthespatialindextypeofthecolumnthathasthespatialinformationintheDBMStable.Thespatial
indexprovidesafastwayforMapInfoProfessionaltoaccessthespatialdatainthetable.Theseven
indextypestochoosefromareSpatialWare,OracleSpatial,OracleAnnotationText,SQLServerSpatial,
PostGISSpatial,MapInfoProfessional,andXYCoordinates.(YouusetheXYCoordinatesoptionwhen
thereisnoindex.)
IndexColumn
RequiredforallindextypesexceptXYCoordinates.Choosethenameofthespatialcolumn,orinthe
caseofaMapInfoProfessionalindextype,choosethenameoftheMICODEcolumn.
XCoordinate,YCoordinate
RequiredonlyifyouchosetheXYCoordinateorMapInfoProfessionalindextype.ChoosetheXandY
columnsthatcontainthepointdatayouwishtomap.
ObjectType
Forspatialdatabases,selectpoint,linear,orregionobjecttypes.(DefaultstopointobjecttypeforMapInfo
ProfessionalandXYCoordinatesindextypes.)
Point:indicatesthetableonlycancontainpointobjects
Linear:indicatesthetablecanonlycontainlinesandpolylines
Region:indicatesthetablecanonlycontainregionobjects
PerRowStyles
Activatesperrowstylesforthetable,whichenablesyoutousedifferentobjectstylesontheremote
table.YoucanmodifythestylesofindividualobjectsorgroupsofobjectsandsavethemtotheDBMS
table.
ThisoptionisonlyavailablewhentheMapInfo_MapCataloghasthestructuretosupportstyles;itcontains
thecolumnsRENDITIONTYPE,RENDITIONCOLUMN,andRENDITIONTABLE,andwhenthetable
hasaminimumofoneChar(character)column.
StyleColumn
Whenthe"PerRowStyle"checkboxhasbeenselected,youmustalsopickaStyleColumnfromthe
drop-downlistofcandidatecolumns.Anycolumnthatisacharactercolumnisacandidate.Sincethis
columnwillbeoverwrittenwiththestylewhentablesaremodifiedwithinMapInfoProfessional,donot
selectacolumnthatcontainsinformation.
Oncethisisdone,thetableisenabledforperrowstyles.Ifnonewerepreviouslyloadedintothetables
column,thedefaultstylestoredintheMapInfo_MapCatalogSYMBOLcolumnwillbeused.Youmay
setnewstylessimplybymodifyingthestyleintheMapwindowandsavingthetable.
Ifthechosencolumnisread-only(itholdsmorethan254charactersforexample),thenyour
mapdataisread-only.
Note:
ObjectStyle
Dependsontheobjecttypesthatthemappabletablecancontain.Youcansetthedefaultstylethatthe
objectswillusefordisplaywhentheyaredownloaded.
Symbol:DisplaystheSymbolStyledialogboxwhereyoucanselectadefaultsymbolforthepointdata.
Line:DisplaystheLineStyledialogboxwhereyoucanselectadefaultsymbolforthelinedata.
Region:DisplaystheRegionStyledialogboxwhereyoucanselectadefaultsymbolfortheregion
data.
Projection
OpenstheChooseProjectiondialogbox.SpecifytheprojectionfortheDBMStable.Theprojection
mustmatchtheprojectionusedbythecorrespondingremotedatabasetable.
MapInfoProfessional12.5
182
MakingaDBMSTableMappabletoDisplayitonaMap
VB.NET PDF Page Delete Library: remove PDF pages in vb.net, ASP.
VB.NET PDF - How to Delete PDF Document Page in VB.NET. Visual Basic Sample Codes to Delete PDF Document Page in VB.NET Class. Free
how to erase text in pdf online; pdf editor online delete text
C# PDF Page Delete Library: remove PDF pages in C#.net, ASP.NET
C#.NET PDF Library - Delete PDF Document Page in C#.NET. Provide C# Users in C#.NET. How to delete a single page from a PDF document.
how to delete text from pdf with acrobat; how to remove text watermark from pdf
IftheProjectionbuttonisdisabled,theapplicationhasreadtheprojectioninformationfromtheOracle
metadataandwillusethatprojectiontodisplaythefile.
TableBounds
OpenstheSetTableBoundsdialogbox,whichletsyouchoosetheoptionsthatdeterminehowyour
defaultviewandyourentireviewtableboundsarecalculated.Theboundsoptionsyouspecifyinthis
dialogboxdefinebothviews.SelectoneoftheseoptionsandclickOKtoimplementthosebounds
options.
UseDataBound:BydefaultMapInfoProfessionalcalculatestheboundsastheminimumbounding
rectangleofallthedatainthelayer.Thisrequiresscanningthetableandcalculatingthisvalue.This
processcantakesometime,soaprogressbardisplaysshowingyoutheprogressofthisoperation.You
cancancelit,ifnecessary.
UseCoordSysBounds:Youcanusethecoordinatesystembounds,butusuallywedonotrecommend
it.Thecoordinatesystemboundsareusuallymuchlargerthantheactualdatabounds,whichmaymake
findingyourdisplayeddatadifficult.Youareusuallyzoomedouttoofartobeabletolocateyourdata
easily.
UseCustomBounds:Setyourowncustomboundsbasedonthesizeandlocationofyourdata.Click
thisoptiontomodifyorsettheboundsofyourdata.
AboutUpdatingDataBoundsintheMapInfo_MapCatalog
TheMapInfo_MapCatalogcontainstheboundsofthedatawithinthetable.Thisdeterminesthemap
viewwhenopeningthetableasthefirstmapinawindow.TheboundsareseteitherbyEasyLoader
whenloadingthedata,orfromMapInfoProfessional'sSetMinimumBoundingRectangletool.
Theboundsautomaticallyadjustwheninsertingorupdatingspatialobjects.Iftheobjectisoutsidethe
MinimumBoundingRectangle(MBR),MapInfoProfessionalexpandstheMBRandupdatesthe
MapInfo_MapCatalog.Deletingobjectsfromthetabledoesnotalterthebounds.
DecidingtoworkwithLinkedorLiveAccessTables
Therearetwowaysinwhichyoucanworkwithyourdatatables:live(orlivewithcaching)andlinked.
Ifyouarenotworkingwithverymuchdata,asmalldatatablesize,thenitdoesnotmatterifyouchoose
toworkwithliveorlinkedaccess.
AboutLiveAccessTables
YoucanaccessremotedataasaliveaccesstableusingMapInfoProfessional.Itiscalledaliveaccess
becausethereisnolocalcopyofthedata,thatis,alloperationsagainstthedatagodirectlytotheserver.
Thisdiffersfromlinkedtables,whichdownloadasnapshotfromtheremotedatabaseintoanative
MapInfoProfessionaltable.
YoucanperformmostoperationsonaliveaccesstablethatyoudoforaregularMapInfoProfessional
table.Forexample,youcanview,edit,copy,andsavealiveaccesslayerjustasyoucanaregular
MapInfoProfessionaltable.However,youcannotpackormodifyaliveaccesstable'sstructure.
Livewithcacheisthepreferredwaytoaccesslivetables.MapInfoProfessionalprovidessmartcaching
toimproveperformanceoflivedataaccessfromremotedatabases.Duringapanoperation,MapInfo
Professionalretrievesmapdatafromacacheratherthanretrieveitfromtheservereverytime.Only
whenthepanrequiresmapdatanotalreadycontainedinthecache,doesitgototheserver.Closingor
refreshingthetableclearsthecache.
WhentheliveaccesstableiscreatinganewMapwindow,theinitialviewisdeterminedbytheentryin
theMapInfo_MapCatalogtable.ThevaluesintheVIEW_*columns,iftheyexist,describearectangular
183
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
C# PDF Text Extract Library: extract text content from PDF file in
Free online source code for extracting text from adobe PDF document in C#.NET class. Ability to extract highlighted text out of PDF document.
erase pdf text; how to delete text in pdf converter professional
VB.NET PDF Text Extract Library: extract text content from PDF
SharePoint. Extract text from adobe PDF document in VB.NET Programming. Extract file. Extract highlighted text out of PDF document. Image
delete text from pdf file; delete text from pdf with acrobat
areathatistheinitialmapdisplay.IftheliveaccesstableisbeingaddedasalayertoanexistingMap
window,thelayerwillbefittothatMapwindow.
MapInfoProfessionalstoresinformationaboutaliveaccesstableinaTABfile.Thisinformationisknown
asmetadata.MapInfoProfessionalusesmetadatatostoreinformationabouttheliveaccesstablethat
isneededtomanagetransactionsbetweenMapInfoProfessionalandtheserverdatabase.Twoofthe
mostimportantkindsofinformationstoredinthemetadataincludetheconnectionstringandthequery
youbuildfromtheDBMSTableWizard,orExpertdialogbox.
AboutLinkedTables
AlinkedtableisaMapInfoProfessionaltablethatisareplicaofatabledownloadedfromaremote
databaseandretainslinkstoitsremotedatabasetable.(TheremotedatabasetableisknownasaDBMS
table.)WhenMapInfoProfessionaldownloadsatable,itcopiestheentirecontentsofthetabletothe
localmachine.Anychangesyoumaketothecopycanbecommittedtotheservertableatanytime.
Linkedtablescanbeusedstand-aloneorremainlinkedtotheoriginalserverdatabase.Youcanrefresh
linkedtablestorerunqueriesonaregularbasisusingtheRefresh
toolorfromtheTable>
Maintenance>RefreshDBMSTablemenu.Aftereditingdatainalinkedtable,MapInfoProfessional
savesittotheRDBSinamannerthatresolvesanymulti-editingconflicts.Savingtheeditsmadetoa
linkedtablecommitsthemtotheserverdatabaseaswellastothelinkedtable.
ComparingandContrastingLiveandLinkedAccesstoaTable
Usethefollowinginformationtodecidewhethertoworkwithyourremotedatatablesliveorlinked.
LiveTable
LinkedTable
DataisreadfromtheDBMSServeras
required.Whenthedataislocallycached,
AfullreplicaoftheDBMStableis
downloadedtotheclientmachine.The
Definition
thelifeofthecacheislimitedtothecurrent
session.
localreplicaretainsreferencetothe
remotedatasource(ODBC/OCI
Connectionparameters);Thedownloaded
copyisretainedacrosssessionsof
MapInfoProfessional.
Livetablesaresuitableforreadingand
editingdynamicallychangingdata;ordata
Linkedtablesaresuitableforbackdrop
displaydata,ordatathatdoesnotchange
Suitability
setsthatdonotfitwithinthelimitsof2GB
much.Linkedtablesareeditable,aslong
perdatafile.Livetablesarerecommended
asthebasetablestheyarebasedonare
editable.
ifyouwanttomaintaindatasecurity(the
datamustremainonlyinasinglesecure
location).
Thecostofdatatransferisincurredalittle
bitatatime.Livetablesareaccessedreal
Asthedataisentirelylocal,thereisa
one-timecostofdownloadingthedata,
Performance
Factors
timefromthedatabase,asrequired.
butsubsequentaccessisfast,comparable
Optionally,recordsfromthelivetablecan
tonativetableaccess,sincetheuserdoes
belocallycachedforthelengthofthe
notincurthecostofnetworktrafficevery
MapInfoProfessionalsession.Caching
timethedataneedstobeaccessedfor
mapping,orforanalysis.
enhancesperformance,becausethedata
isnotfetchedmultipletimesastheuser,
zooms,pans,orbrowsesaroundthedata.
Thisisanetworkintensiveoption.
Linkedtablesarelimitedto2GBperdata
file;Linkedtablesarenotrefreshedunless
Limitations
theuserexplicitlyrefreshesthetable.You
cannotpackalinkedtable.Youcannot
modifythetablestructureofalinkedtable.
MapInfoProfessional12.5
184
DecidingtoworkwithLinkedorLiveAccessTables
C# PDF insert text Library: insert text into PDF content in C#.net
C#.NET PDF SDK - Insert Text to PDF Document in C#.NET. This C# coding example describes how to add a single text character to PDF document. // Open a document.
delete text from pdf; delete text pdf preview
C# PDF metadata Library: add, remove, update PDF metadata in C#.
C#.NET PDF SDK - Edit PDF Document Metadata in C#.NET. Allow C# Developers to Read, Add, Edit, Update and Delete PDF Metadata in .NET Project.
how to delete text in a pdf acrobat; how to delete text in pdf preview
Formoreinformation,seeImprovingLiveAccessPerformanceintheHelpSystem.
OpeningaDBMSTableinMapInfoProfessional
Aftercompletingtheinstructionsinthefollowingsections:
• CreatingaDataSourceConnection
• CreatingaMapCatalogintheDBMStoWorkwithData
• MakingaDBMSTableMappabletoDisplayitonaMap
youarereadytoconnecttoyourdatasourcesandthedatabasetablesyouwanttoworkwith.Ifyouare
notfamiliarwiththedetailsofyourremotedatabasetype,discussyourrequirementswithyourdatabase
administratortofindoutthebasicinformationnecessarytoconnecttoyourdatabase.
OptionsforOpeningTables
WhenopeningDBMStables,thereareanumberofoptionsfor:
• Whichtablesinthedatabasetoopenorselecttoopenalloftheavailabletables.
• Whethertoopenthetablesliveorlinked.Ifselectinglinked,youcanopenthemwithcaching.You
cansetthisoptionindividuallyforatabletooverridewhatissetforallthetablesyouwillopen.
• Howyouwantthedatatodisplayonthemapbyselectingpoint,line,andregionstyleoptions.You
canchange:symboltype,color,andsize,aswellasthelabelfont;linecolorandpattern;regionfill
colorandpattern,andbordercolorandpattern.
• Columnandrowfiltersontables.Filtersletyoureducetheamountofinformationthatyouwillwork
withandreducethetimeittakestofetchandsavethedata.
• AdirectorywheretheMapInfoTABfile(withthesamenameasthetable)willbesaved.
Youcanapplytheseselectionstoallofthetablesyouwillopenandalsoselectoverridesforindividual
tables.
PerformingQueriesonTables
Whenperformingaqueryonatablethequeryexecuteswhen:
• Linkedtables:Openingthetableforthefirsttime,andwhenrefreshingthetable.
• Livewithcache:Addingthetabletothemap,andzoomingorpanninginthemap.
• Livewithoutcache:Addingthetabletothemap,zoomingorpanninginthemap,andclickinginthe
mapwiththeSelectorInfotools.
Youcanspecifywhichrecordstoretrievefromthedatabasebyattributeorbygeography.Thequery
syntaxisspecifictothedatabasethatyouareaccessing.MapInfoProfessionaltranslatessome
expressionswhenpassingaquerytothedatabase,suchasObject,Within,Selection,and
Current_Mapper.Youmaysaveyourqueries,sothatyoucanreusethem.
TablesandMetadata
MapInfoProfessionalstoresinformationaboutatableinthe.tabfile'smetadata,whichisnotdisplayed
onthemap.MapInfoProfessionalusesmetadatatomanagetransactionsbetweenMapInfoProfessional
andtheserverdatabase.Twoofthemostimportantkindsofinformationstoredinthemetadatainclude
theconnectionstringandthequeryyoubuildfromtheDBMSTableWizard,orExpertdialogbox.
OpeningaDBMSTable
ThissectiondescribeshowtoopenaDBMStable.
TheconnectiontoyourDBMSmustbeopenbeforeyoucanopenatable.Ifyouhavenotyetopeneda
connectionorifyouhaverestartedMapInfoProfessional(andmustre-openaconnection),see
ReconnectingtoyourDataSourceafterStartup.
185
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
C# PDF Text Search Library: search text inside PDF file in C#.net
C#.NET. C# Guide about How to Search Text in PDF Document and Obtain Text Content and Location Information with .NET PDF Control.
online pdf editor to delete text; delete text pdf
C# PDF Convert to Text SDK: Convert PDF to txt files in C#.net
All text content of target PDF document can be copied and pasted to .txt files by keeping original layout. C#.NET class source code
how to erase in pdf text; how to delete text in pdf using acrobat professional
Toopenadatabasetable:
1. SelectFile>Open.
2. IntheOpendialogbox,fromtheFilesoftypelist,selecttheDBMSconnectiontoworkwith.
TheDBMSconnectionsthatyoucreatedpreviously(asdescribedunderCreatingaDataSource
Connection)areatthebottomoftheFilesoftypedrop-downlist.Ifyouhavemorethanone
connection,thentheconnectionnamecontainsasequentialnumberindicatingtheorderinwhich
theconnectionwasadded.
TheSelectOneorMoreTablestoOpendialogboxopens.
3. IntheDatabaseTableslist,selectatabletoopenbyaddingacheckmarkbesidethetablename.
Youcanselectoneormoretables.Onlythetablesthathaveacheckmarkbesidethemwillopen.
4. Optionally,selecthowyouwantthedatatodisplayonthemapbyselecting(highlighting)thetable
nameandclickingStyle.
ThisopenstheChangeTableObjectStyledialogboxwhereyoucanspecifythedisplaystylefor
geometry(spatialobjecttypes),suchassymbols,lines,andregionsinthetable.Thecustomstyles
thatyousetonlyapplytothetablethatyouhighlighted(whetherithasacheckmarkbesideitornot).
Toselectmorethanonetable,pressCtrl
whileselectingtablenames.Yourstylechoicesaremade
toallofthetablesthatyouselect(thatarehighlightedintheDatabaseTableslist).
5. FromthePreferredViewdrop-downlist,selecttheviewyouwantofthisdata.
• Automatic-MapInfoProfessionalchoosesthemostappropriateview.Ifthedataismappable(for
example,graphicobjectsareattachedtothedata),forexample,MapInfoProfessionalopensthe
tableinaMapwindow.IfyouhaveaMapwindowdisplayedandthetableyouwanttoopenis
mappable,MapInfoProfessionalwillautomaticallyopenthetableinthecurrentMapwindow.If
thedataisnotmappable,MapInfoProfessionalwillattempttoopenthetableinaBrowserwindow.
Ifthetablecannotbemappedorbrowsed,MapInfoProfessionalopensthetableusingtheNo
Viewoption(nodataisdisplayed).
• Browser-MapInfoProfessionalattemptstoopenthetableinaBrowserwindow.
• CurrentMapper-MapInfoProfessionalattemptstoaddyourdatatothecurrentMapwindow.
• NewMapper-MapInfoProfessionalattemptstoopenthetableinanewMapwindow.
• NoView-MapInfoProfessionalopensthetablemakingthedataavailableforotheruses,butno
dataisdisplayed.
WhenyouopenatableandselectanoptioninthePreferredViewdrop-downlist,MapInfo
Professionalrememberswhatyouselectedandusesthesameoptionthenexttimeyouopena
table.
6. ClickOK.
IfaMapInfomessagedialogdisplaysaskingifyouwanttooverwritetheexistingfile,clickOK.You
havepreviouslyopenedthisfileandthereisatemporarycopyofthefileonyourmachine.MapInfo
Professionalwilloverwritethistemporarycopy.
Thetable,ortables,fromyourselectionopeninaMapwindow(orinaTablebrowserifthedataisnot
mappable).
MapInfoProfessional12.5
186
OpeningaDBMSTableinMapInfoProfessional
CreatingaNewDBMSTable
TocreateanewDBMStable:
1. ChooseFile>NewTable.
2. IntheNewTabledialogbox:
a. Specifyhowyouwantthetableopened:Browser,Mapper,orCurrentMapper.
b. SpecifywhetheryouwantthetablestructuretobebasedonanexistingtableoryouwantMapInfo
Professionaltocreateanewtablestructure.
c. ClickCreate.
3. IntheNewTableStructuredialogboxspecifythefieldname,fieldtype,numberofcharacters
(width),andwhetherornottoindexforeachfieldinyournewdatabase.ClickCreate.
187
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
Ifyouareusingthestructurefromanothermappabletable,thenMapInfoProfessionalsetsthenew
tableprojectiontotheprojectionofthesourcetable.Collectively,thisinformationisthestructureof
yourdatabase.
Youindicatewhetherthetableismappablebyassociatinggraphicobjectswithrecordsand,
ifso,whetherthemapistobeanearthoranon-earthmap.
Note:
4. IntheCreateNewTabledialogbox,fromtheSaveastypedrop-downlist,selectaDBMStype.
ThedialogboxdisplaysDBMSconnectioncontrols.
IntheFilenamebox,typeafilenameandclickSave.
Dependingonthedatabasetypethatyouselected,thenewtableopensinMapInfoProfessionalorthe
NewDBMSTableOptionsdialogboxopens.IfyouseetheNewDBMSTableOptionsdialogboxthen
continuetothenextsection.
SettingNewDBMSTableOptions
TosetnewDBMStableoptions,followtheinstructionsunderCreatingaNewDBMSTable.Depending
onthedatabasetypethatyouselect,theNewDBMSTableOptionsdialogboxopens.Thisdialogbox
hasthreetabs,General,Spatial,andStyles.Refertothefollowingsectionsforinformationabouteach
tabofoptions.
IfyouclearedtheMakeTableMappablecheckboxinCreateNewTabledialogbox,thentheDBMS
TableOptionsdialogboxshowsonlytheGeneraltab.
GeneralTab
UndertheGeneraltabcompletetheappropriateselections:
• TABfilelocation-Displaysthenameandpathofthe.tabfilethatwillbecreated.Youcanmanually
typeafilenameorusetheSaveAsdialogbox(viaBrowsebutton)tochooseafilename.MapInfo
ProfessionalusesthelastdirectorywhereyousavedaDBMS.tabwhenconstructingthedefault
filenamefullpath.Ifthisdirectorydoesnotexist,thentheRemoteTablespreferencedirectoryisused.
ThefilenamepartofthedefaultpathisbasedonthenameofthespecifiedDBMStablename.
• Browse(...)button-DisplaystheSaveAsdialogboxsotheusercanchoosea.tabfilename.Initialized
withthetextinthe.tabfilenameeditbox.
• PrimaryKeyColumn-Letsyouspecifyakeycolumnforthenewtable.Withoutakeycolumna
DBMStablecannotbeopenasliveaccessandcanonlybeopenedreadonlyasLinked.
IfthePrimaryKeyColumncheckboxisselected,thenthecorrespondingcomboboxisenabled.
YoucaneitherchooseacolumnthatwasspecifiedintheNewTableStructuredialogboxorspecify
anewcolumnbytypingintothecombobox'seditcontrol.
BydefaultthePrimaryKeyColumncheckboxisselectedandanewcolumnisspecified.Thedefault
nameofthenewcolumndependsontheDBMSconnection:MI_PRINXforOracleSpatial,
SW_MEMBERforallothers.
• DownloadData(LinkedTable)-Selecttoestablishalinkedconnectiontothistable.
• LiveAccess-Selecttoaccessthistablewithaliveconnection.
• Cache-Selecttosavethetabletothelocalbufferandthenreadthetabledatafromthebuffer.Access
timetodataisfasterbutyouarenotworkingwiththemostcurrentversion.Refreshoccurswhenyou
zoom,pan,orselect.Unselecttoreadthetabledirectlyfromthedatasource,whichisthecurrent
version.
TheCachecheckboxenablesafterselectingtheLiveAccessoption.
SpatialTab
ClicktheSpatialtabandspecifytheindextypeandcoordinatecolumnselections:
• IndexType-Thissettingdeterminesthetypeofspatialindexingusedonthetable.TypesMapInfo
(MICODE)andXYarealwaysavailable.Serverspecifictypesmayalsobelisted.Theindextype
selectionaffectsthestateoftheotherthreecontrolsinthistab.
MapInfoProfessional12.5
188
OpeningaDBMSTableinMapInfoProfessional
• IndexColumn-Specifytheprimaryspatialindexcolumnfromthelist.Thisoptionisalwaysavailable,
exceptwhentheindextypeisXY.
• XCoordinate-SpecifytheXorlongitudecolumninthedatabasefromthelist.Thisisonlyavailable
forMapInfo(MICODE)orXYtypes.Youcaneitherchooseafloatcolumnthatwasspecifiedinthe
NewTableStructuredialogboxorspecifyanewcolumnbytypingintothecombobox'seditcontrol.
• YCoordinate-SpecifytheYorlatitudecolumninthedatabasefromthelist.Thisisonlyavailable
forMapInfo(MICODE)orXYtypes.Youcaneitherchooseafloatcolumnthatwasspecifiedinthe
NewTableStructuredialogboxorspecifyanewcolumnbytypingintothecombobox'seditcontrol.
StylesTab
ClicktheStylestabandcompletetheappropriateselections:
• PerRowStyle-CheckthePerRowStylecheckboxtoenableperrowsymbology.Thestyle
informationforeachobjectismaintainedinacharactercolumnofthetable.Ifunchecked,thenthe
styleofallobjectsinthetableisdeterminedbythedefaultobjectstylesmaintainedintheMapCatalog.
IfPerRowStyleischecked,thentheStyleColumncomboboxisenabled.BydefaultPerRowStyle
ischeckedandanewcolumnnamedMI_STYLEisspecified.
• StyleColumn-SelectfromthelistacharactercolumnthatwasspecifiedintheNewTableStructure
dialogboxoranewcolumnbytypingintothecombobox'seditcontrol.
• DefaultObjectStyles-ThedefaultobjectstylesareusedwhenPerRowStyleisnotturnedonfor
atable,orthestyleinfoforaparticularobjectdoesnotexist(thestylecolumnforthatrowisempty).
Thedefaultstyleinformationspecifiedhereisenteredintothemapcatalog.Thedefaultsymbol,line,
andregionsettingswithinMapInfoProfessionalareusedtoinitializethesecontrols.
RefreshingLiveandLinkedRemoteTables
Ifthetableyouareworkingwithislinked,thenrefreshittoupdateyourdatawithchangesfromthe
remotedatabase.Ifthetableislive,MapInfoProfessionalreadsthelatestdatafromthetable.
Whenyouopenaremotetable,MapInfoProfessionalenablestheRefreshDBMSTable
toolsoyou
canrefreshthedatainthattable.Refreshingatable:
• Checksthedatabaseforchanges.
• Reappliesanyqueryconditions(thesearestatic).
• Iffilteringusingthecurrentmaporselection,thenthefilteralwaysappliestothetable.Tosetadifferent
mapextent,reopenthetablefromthedatabase.
Torefreshalinkedorlivetable:
1. Dooneofthefollowing:
• ClicktheRefreshDBMSTable
toolontheDBMStoolbar
• FromtheTablemenu,selectMaintenance>RefreshDBMSTable
• PressCtrl+D
inanactiveBrowserwindow(clickingonaBrowserwindowmakesitactive)
2. IntheRefreshTabledialogbox,selectthetabletorefreshandthenclickOK.
Thespecifiedtablerefreshes.
UnlinkingaTablefromaRemoteDatabase
YoucanunlinkatablefromitsremotedatabaseusingtheUnlinkDBMSTablemenuoption.Unlinking
atableremovesthelinktotheremotedatabase.Thisdoesnotworkifeditsarependingonthelinked
table,youmustfirstupdateanypendingeditswiththeSaveTablemenuoption.Theendproductisa
normalMapInfoProfessionalbasetablewithouttablelinkagesandnon-editablefieldsmadeeditable.
Tounlinkatable:
189
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
1. OntheTablemenu,selectMaintenanceandthenUnlinkDBMSTable.
2. IntheUnlinkTabledialogbox,selectthenameofthetabletounlinkandthenclickOK.
Thespecifiedtableunlinks.
SavingaDBMSTable
YousavechangestoaMapInfoProfessionallinkedorlivetablethesamewayyousavearegularMapInfo
Professionaltable,withtheSaveTablemenuoption.
Savingalinkedorlivetablesavestherecordsontheremotedatabase.BeforeMapInfoProfessional
updatesrecordsfromalinkedorlivetable,itevaluatestherecordsinaprocesscalledconflictresolution.
IfMapInfoProfessionalfindsconflictsbetweenthedataontheremotedatabaseandrecordsinthelinked
table,sincethetimeofitsdownload,theResolveConflictsdialogboxdisplays.Usethisdialogboxto
resolveconflicts.
• Formoreinformation,seeSavingChangesMadetoaDBMSTableintheHelpSystem.
ConflictResolutionwhenMultipleUsersAccessaRemoteTable
Otherusersmaychangeordeleterecordsinatableontheremotedatabaseafteritwasdownloaded
intoMapInfoProfessional.Asaresult,conflictsmayexistbetweenthedataresidingontheremote
databaseandthenewdatathatyouwanttouploadtotheremotedatabase.
Iftherearechangestorecordsintheoriginaldatasourcewhensavingatablebacktoaremotedatabase,
aResolveConflictsdialogboxdisplays.Aconflictexistswhentheoriginalstateoftherecorddoesnot
matchtheserverstate.Thisimpliesthatanotheruserhasupdatedthisdatabasesinceitwasextracted
byMapInfoProfessional.
IntheResolveConflictsdialogbox,youcanchoosethefieldstousefromtheconflictingrecordsto
updatethedatabasewith.Therearethreeconsiderationswhenupdatingarecord:
• Theoriginalserverstateoftherecord(therecordasitappearedwheninitiallyextractedfromthe
database).
• Thecurrentlocalstateoftherecord(therecordasitappearsinthesessionofMapInfoProfessional
makingtheupdate,possiblyaftereditingbytheuser).
• Thecurrentserverstateoftherecord(therecordasitappearsinthedatabaseatthetimeofthe
update).
TheResolveConflictsdialogboxdisplaysonceforeachconflictingrecord.Atanypointinthisprocess,
youmaychoosetoleavethisinteractivemodeandhavetherestoftheconflictsresolvedautomatically.
Inthatcase,youcanusealllocalvaluesorallservervaluestoresolvetheconflictsintherecords.
Foreachconflictfoundduringacommit,amodaldialogboxdisplays.Thisboxdisplaysenoughinformation
foryoutodecidewhichdatavaluestousetoupdatetherowinquestion.
Defaultresolution
Typeofconflict
Useservervalue
Valuechangedonserver,localvalueunchanged
Uselocalvalue
Valuechangedonserver,localvaluechanged
Thedialogboxprovidesyouwiththefollowingoptions:
Column
Showsthenameofthecolumnintherecordthathasdatawhichisinconflictandneedstoberesolved.
Ifthecolumnnameistoolonganddoesnotfitintothelistbox,atruncatedrepresentationwillbeshown
instead.ItsfullvaluedisplaysintheColumnfield.
MapInfoProfessional12.5
190
OpeningaDBMSTableinMapInfoProfessional
Documents you may be interested
Documents you may be interested