how to create pdf viewer in c# : Copy text pdf application Library tool html asp.net wpf online MapInfoProUserGuide21-part1782

•XCoordinate-SpecifytheXorlongitudecolumninthedatabasefromthelist.Thisisonlyavailable
forMapInfo(MICODE)orXYtypes.Youcaneitherchooseafloatcolumnthatwasspecifiedin
theNewTableStructuredialogboxorspecifyanewcolumnbytypingintothecombobox'sedit
control.
•YCoordinate-SpecifytheYorlatitudecolumninthedatabasefromthelist.Thisisonlyavailable
forMapInfo(MICODE)orXYtypes.Youcaneitherchooseafloatcolumnthatwasspecifiedin
theNewTableStructuredialogboxorspecifyanewcolumnbytypingintothecombobox'sedit
control.
StylesTab
ClicktheStylestabandcompletetheappropriateselections:
•PerRowStyle-CheckthePerRowStylecheckboxtoenableperrowsymbology.Thestyle
informationforeachobjectismaintainedinacharactercolumnofthetable.Ifunchecked,then
thestyleofallobjectsinthetableisdeterminedbythedefaultobjectstylesmaintainedintheMap
Catalog.
IfPerRowStyleischecked,thentheStyleColumncomboboxisenabled.BydefaultPerRow
StyleischeckedandanewcolumnnamedMI_STYLEisspecified.
•StyleColumn-SelectfromthelistacharactercolumnthatwasspecifiedintheNewTable
Structuredialogboxoranewcolumnbytypingintothecombobox'seditcontrol.
•DefaultObjectStyles-ThedefaultobjectstylesareusedwhenPerRowStyleisnotturnedon
foratable,orthestyleinfoforaparticularobjectdoesnotexist(thestylecolumnforthatrowis
empty).Thedefaultstyleinformationspecifiedhereisenteredintothemapcatalog.Thedefault
symbol,line,andregionsettingswithinMapInfoProareusedtoinitializethesecontrols.
RefreshingLiveandLinkedRemoteTables
Ifthetableyouareworkingwithislinked,thenrefreshittoupdateyourdatawithchangesfromthe
remotedatabase.Ifthetableislive,MapInfoProreadsthelatestdatafromthetable.
Whenyouopenaremotetable,MapInfoProenablestheRefreshDBMSTable
toolsoyoucan
refreshthedatainthattable.Refreshingatable:
•Checksthedatabaseforchanges.
•Reappliesanyqueryconditions(thesearestatic).
•Iffilteringusingthecurrentmaporselection,thenthefilteralwaysappliestothetable.Toseta
differentmapextent,reopenthetablefromthedatabase.
Torefreshalinkedorlivetable:
1. Dooneofthefollowing:
•ClicktheRefreshDBMSTable
toolontheDBMStoolbar
•FromtheTablemenu,selectMaintenance>RefreshDBMSTable
•PressCtrl+D
inanactiveBrowserwindow(clickingonaBrowserwindowmakesitactive)
2. IntheRefreshTabledialogbox,selectthetabletorefreshandthenclickOK.
211
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
Copy text pdf - extract text content from PDF file in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Feel Free to Extract Text from PDF Page, Page Region or the Whole PDF File
extract text from pdf online; get text from pdf c#
Copy text pdf - VB.NET PDF Text Extract Library: extract text content from PDF file in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
How to Extract Text from PDF with VB.NET Sample Codes in .NET Application
copy text from pdf without formatting; extract text from pdf c#
Thespecifiedtablerefreshes.
UnlinkingaTablefromaRemoteDatabase
YoucanunlinkatablefromitsremotedatabaseusingtheUnlinkDBMSTablemenuoption.Unlinking
atableremovesthelinktotheremotedatabase.Thisdoesnotworkifeditsarependingonthe
linkedtable,youmustfirstupdateanypendingeditswiththeSaveTablemenuoption.Theend
productisanormalMapInfoProbasetablewithouttablelinkagesandnon-editablefieldsmade
editable.
Tounlinkatable:
1. OntheTablemenu,selectMaintenanceandthenUnlinkDBMSTable.
2. IntheUnlinkTabledialogbox,selectthenameofthetabletounlinkandthenclickOK.
Thespecifiedtableunlinks.
SavingaDBMSTable
YousavechangestoaMapInfoProlinkedorlivetablethesamewayyousavearegularMapInfo
Protable,withtheSaveTablemenuoption.
Savingalinkedorlivetablesavestherecordsontheremotedatabase.BeforeMapInfoProupdates
recordsfromalinkedorlivetable,itevaluatestherecordsinaprocesscalledconflictresolution.
IfMapInfoProfindsconflictsbetweenthedataontheremotedatabaseandrecordsinthelinked
table,sincethetimeofitsdownload,theResolveConflictsdialogboxdisplays.Usethisdialog
boxtoresolveconflicts.
•Formoreinformation,seeSavingChangesMadetoaDBMSTableintheHelpSystem.
ConflictResolutionwhenMultipleUsersAccessaRemoteTable
Otherusersmaychangeordeleterecordsinatableontheremotedatabaseafteritwasdownloaded
intoMapInfoPro.Asaresult,conflictsmayexistbetweenthedataresidingontheremotedatabase
andthenewdatathatyouwanttouploadtotheremotedatabase.
Iftherearechangestorecordsintheoriginaldatasourcewhensavingatablebacktoaremote
database,aResolveConflictsdialogboxdisplays.Aconflictexistswhentheoriginalstateofthe
recorddoesnotmatchtheserverstate.Thisimpliesthatanotheruserhasupdatedthisdatabase
sinceitwasextractedbyMapInfoPro.
IntheResolveConflictsdialogbox,youcanchoosethefieldstousefromtheconflictingrecords
toupdatethedatabasewith.Therearethreeconsiderationswhenupdatingarecord:
•Theoriginalserverstateoftherecord(therecordasitappearedwheninitiallyextractedfromthe
database).
212
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
C# PDF Page Extract Library: copy, paste, cut PDF pages in C#.net
C#.NET PDF Library - Copy and Paste PDF Pages in C#.NET. Easy Ability to copy selected PDF pages and paste into another PDF file. The
copy paste text pdf; copy text from pdf online
VB.NET PDF Page Extract Library: copy, paste, cut PDF pages in vb.
Extract, Copy, Paste PDF Pages. |. Home ›› XDoc.PDF ›› VB.NET PDF: Copy and Paste PDF Page. Ability to copy PDF pages and paste into another PDF file.
copy formatted text from pdf; cut and paste text from pdf document
•Thecurrentlocalstateoftherecord(therecordasitappearsinthesessionofMapInfoPromaking
theupdate,possiblyaftereditingbytheuser).
•Thecurrentserverstateoftherecord(therecordasitappearsinthedatabaseatthetimeofthe
update).
TheResolveConflictsdialogboxdisplaysonceforeachconflictingrecord.Atanypointinthis
process,youmaychoosetoleavethisinteractivemodeandhavetherestoftheconflictsresolved
automatically.Inthatcase,youcanusealllocalvaluesorallservervaluestoresolvetheconflicts
intherecords.
Foreachconflictfoundduringacommit,amodaldialogboxdisplays.Thisboxdisplaysenough
informationforyoutodecidewhichdatavaluestousetoupdatetherowinquestion.
Defaultresolution
Typeofconflict
Useservervalue
Valuechangedonserver,localvalueunchanged
Uselocalvalue
Valuechangedonserver,localvaluechanged
Thedialogboxprovidesyouwiththefollowingoptions:
Column
Showsthenameofthecolumnintherecordthathasdatawhichisinconflictandneedstobe
resolved.Ifthecolumnnameistoolonganddoesnotfitintothelistbox,atruncatedrepresentation
willbeshowninstead.ItsfullvaluedisplaysintheColumnfield.
OriginalDBMS
Showstheoriginaldataasitappearedwhenextractedfromthedatabase.Iftheoriginaldataistoo
longanddoesnotfitintothelistbox,atruncatedrepresentationwillbeshowninstead.Itsfullvalue
canbedisplayedintheOriginalfield.
CurrentMapInfoPro
ShowsthedataasitappearsintheMapInfoProlinkedtableyouaretryingtosave.TheMapInfo
ProfieldwillbeblankiftherecordhasbeendeletedfromtheMapInfoProdatabase.Ifthedatafrom
theMapInfoProlinkedtableistoolonganddoesnotfitintothelistbox,atruncatedrepresentation
willbeshowninstead.ItsfullvaluecanbedisplayedintheMapInfoProfield.
CurrentDBMS
Showsdataasitappearsintheremotedatabaseatthetimeoftheupdate.(Thisdatamighthave
beenchangedbyanotherusersinceitwasdownloadedintoanMapInfoProlinkedtable.)The
Currentfieldwillbeblankiftherecordhasbeendeletedontheremotedatabase,afterbeing
downloadedintoanMapInfoProlinkedtable.Ifthecurrentdatafromtheremotedatabaseistoo
longanddoesnotfitintothelistbox,atruncatedrepresentationwillbeshowninstead.Itsfullvalue
canbedisplayedintheCurrentfield.
213
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
C# PDF Image Extract Library: Select, copy, paste PDF images in C#
PDF ›› C# PDF: Extract PDF Image. How to C#: Extract Image from PDF Document. Support PDF Image Extraction from a Page, a Region on a Page, and PDF Document.
.net extract pdf text; delete text from pdf
VB.NET PDF Image Extract Library: Select, copy, paste PDF images
VB.NET PDF - Extract Image from PDF Document in VB.NET. Support PDF Image Extraction from a Page, a Region on a Page, and PDF Document in VB.NET Project.
extract text from pdf c#; extract all text from pdf
CurrentMapInfoPro
SelectthischeckboxtoupdatetheremotedatabasewiththevaluefromtheMapInfoProlinked
table.
IfthecurrentrecordonthedatabaseortheMapInfoProrecordwasdeleted,thenthischeckboxis
notavailable.Instead,youmustusetheMapInfoProorCurrentbutton.
CurrentDBMS
Selecttoretainthecurrentvalueontheremotedatabase.Ifthecurrentrecordonthedatabaseor
theMapInfoProrecordwasdeleted,thenthischeckboxisnotavailable.Instead,youmustusethe
MapInfoProorCurrentbutton.
MapInfobutton
ThisbuttonselectsalltheMapInfoProvalues.Iftherecordyouaretryingtoresolvewasdeleted
fromtheMapInfoProdatabase,selectingtheMapInfobuttonwilldeletetherecordfromtheremote
database.Iftherecordyouaretryingtoresolvewasdeletedfromtheremotedatabase,selecting
theMapInfobuttonwillinsertthenewrecordintotheremotedatabase.
Currentbutton
ThisbuttonselectsallthecurrentDBMSvalues.Iftherecordyouaretryingtoresolvewasdeleted
fromtheMapInfoProdatabase,selectingtheCurrentbuttonwillignorethedeletionandretainthe
currentrecordintheremotedatabase.Iftherecordyouaretryingtoresolvewasdeletedfromthe
remotedatabase,selectingtheMapInfobuttonwillinsertthenewrecordintotheremotedatabase.
Column
Showsthefullnameofthecolumnhighlightedinthelistbox.
OriginalDBMS
Showsthefullvalueoftheoriginaldatahighlightedinthelistbox.
CurrentMapInfo
ShowsthefullvalueoftheMapInfoProdatahighlightedinthelistbox.
CurrentDBMS
Showsthefullvalueofthecurrentremotedatabasedatahighlightedinthelistbox.
StopCommit
TheStopCommitbuttonterminatestheentireupdate.Aseconddialogboxconfirmsthatthisis
whatyoureallywant.
Automatic
TheAutomaticbuttoncausestheinteractiveconflictresolutiontoend.Adialogboxdisplaysto
allowyoutoselecttheautomaticconflict-resolutionmodesyouwanttousefortheremainderofthis
update.Youcanselectonetwoautomaticmodesfromthedialogbox.YoucanacceptMapInfoPro
values,orthevaluescurrentlyresidingontheremotedatabase.
214
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
VB.NET PDF copy, paste image library: copy, paste, cut PDF images
XDoc.PDF ›› VB.NET PDF: Copy, Paste, Cut Image in Page. VB.NET PDF - Copy, Paste, Cut PDF Image in VB.NET. VB.NET: Copy and Paste Image in PDF Page.
extract text from pdf online; copy text from scanned pdf
C# PDF copy, paste image Library: copy, paste, cut PDF images in
|. Home ›› XDoc.PDF ›› C# PDF: Copy, Paste, Cut Image in Page. C#.NET PDF SDK - Copy, Paste, Cut PDF Image in C#.NET. C# Guide
delete text from pdf online; copy text from pdf without formatting
DisconnectingfromaRemoteDatabase
Disconnectingfromaremotedatabaseserverisasimpleoperation.
Todisconnectfromaremotedatabaseserver:
1. FromtheDBMSToolbar,dooneofthefollowing:
•ClicktheDisconnectDBMS
tool.
•OntheFilemenu,clickCloseDBMSConnection.
2. IntheCloseDBMSConnectiondialogbox,theConnectionlistdisplaysalltheopenconnections.
Selecttheconnection(s)youwanttocloseandclickOK.
Theselectedconnection(s)close.
Youcannotdisconnectifyouhavealivetableopenusingtheconnectionyouaretryingto
close.
Note:
WorkingwithStylesinDBMSTables
Atablemayuseonestyleforallobjectswithinatable,orcontaindifferentstylesforeachrow,called
perrowstyles(perrowstyleisoptional).Therearetworequirementsforsettingupperrowstyles:
•ArowmustexistintheDBMStable
•Youmustsetupamapcatalogentrytoactivatetherowstyle.
UsingPerRowStylesforDBMSTableLayers
PerRowStylesallowstheuseofdifferentobjectstylesonaremotedatabase.Youcanmodifythe
stylesofindividualobjectsorgroupsofobjectsandsavethemtoaDBMStable.TousePerRow
Styles,theDBMStablemustbesetupcorrectly,andyourMapInfo_MapCatalogmusthavethe
appropriatestructure:
•TheMapInfo_MapCatalogmustcontaincolumnsthatsupporttheuseofstyles.Theyare:
RENDITIONTYPE,RENDITIONCOLUMN,andRENDITIONTABLE.
•Themaptableitselfmusthaveacharactercolumnwideenoughtostorethecompletestylestring.
Stylestringsvaryinwidth.Werecommendaminimumof50charactersbeprovided.Ifyouplan
tousecustomsymbols,whichusemuchlongerstrings,allow200characters.
•TheentryforthetableintheMapInfo_MapCatalogmustbesetcorrectly.Thismeansthatthe
RENDITIONTYPEis1,andtheRENDITIONCOLUMNcontainsthenameofthecolumnthatwill
containthestylestring.ThisentryissetbyEasyLoaderiftheMapInfo_MapCatalogcontainsthe
newcolumns,oritmaybesetusingtheMakeTableMappablefunction.
ChangingtheSymbolStyleinaMappableDBMSTable
TheChangeDBMSTableSymbolmenuoptionallowsyoutochangethesymbolattributesforthe
pointobjectsinamappableDBMStable.
215
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
C# PDF insert text Library: insert text into PDF content in C#.net
Text to PDF. C#.NET PDF SDK - Insert Text to PDF Document in C#.NET. Providing C# Demo Code for Adding and Inserting Text to PDF File Page with .NET PDF Library.
get text from pdf image; extract text from pdf to word
C# PDF Convert to Text SDK: Convert PDF to txt files in C#.net
C#.NET PDF SDK - Convert PDF to Text in C#.NET. Integrate following RasterEdge C#.NET text to PDF converter SDK dlls into your C#.NET project assemblies;
copy paste text pdf file; a pdf text extractor
1. OntheTablemenu,pointtoMaintenanceandclickChangeDBMSTableSymbol.Or,select
theChangeSymboltool.
2. IntheSelectDBMSTabledialogbox,selectatable.OnlymappableDBMStablesdisplay.
3. IntheChangeTableObjectStyledialogbox,specifynewstyleattributesfortheobjectsinthe
selectedtable.
4. Refreshthelinkedtableforthestylechangetotakeeffect.
Working with Remote Tables from Specific Databases
Youcanspecifywhethertoloadandworkonanentiretableoronlyspecificcolumnsorrowsfrom
atable.
WorkingwithSQLServerTables
ConvertingUnsupportedGeometriesinSQLServerandSQLServerSpatialWare
SometimeswhenyouarecreatingaMapinMapInfoProandyouarestoringtheresultsinSQL
Serveryoucreatemapswhichusegeometriesthatarenotsupported:
•SQLServerSpatialdoesnotsupportarcs,andlinesthatdonothavedistinctpoints.
•SQLServerSpatialWaredoesnotsupportarcs,ellipses,androundedrectangles.
IfyouhavecreatedamapyoudonotwanttolosebutcannotsavetotheDBMSofyour
choiceduetounsupportedgeometries,thenusetheSaveAsmenuoptionandsavethe
mapwithouttheunsupportedgeometries.
Note:
IfyoutrytosaveamapwithunsupportedspatialgeometrytypesinSQLServerSpatialorSQL
ServerSpatialWare,thesearetheresults:
•SpatialGeometryTypeswithAllUnsupportedObjects:Ifyouhavecreatedamapthatmight
containalloftheunsupportedobjectsandyouaretryingtosavetoSQLServerSpatialorSQL
ServerSpatialWare,thismessagedisplays:
Table has unsupported objects (rounded rectangles, ellipses or
arcs). Convert to regions and/or polylines?
ClickYestoconverttheunsupportedobjectstoregionsorpolylines;youwouldselectNotodecline
toconverttheunsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedto
theSQLServerSpatialorSQLServerSpatialWaredatabase.
216
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
VB.NET PDF Convert to Text SDK: Convert PDF to txt files in vb.net
VB.NET PDF - Convert PDF to Text Using VB. Integrate following RasterEdge text to PDF converter SDK dlls into your VB.NET project assemblies;
copy text from pdf to word; extract text from pdf file
•SpatialGeometrytypeswithRegionObjectsOnly:Ifyouhavecreatedamapthatcontains
regionobjectsonlyandyouaretryingtosavetoSQLServerSpatialorSQLServerSpatialWare,
thismessagedisplays:
Table has unsupported objects (rounded rectangles or ellipses).
Convert to regions?
ClickYestoconverttheunsupportedobjectstoregions;youwouldselectNotodeclinetoconvert
theunsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedtotheSQL
ServerSpatialorSQLServerSpatialWaredatabase.
•ForSpatialGeometrytypeswithLineObjectsOnly:Ifyouhavecreatedamapthatcontains
lineobjectsonlyandyouaretryingtosavetoSQLServerSpatialorSQLServerSpatialWare,
thismessagedisplays:
Arc is an unsupported object. Convert to polylines?
ClickYestoconverttheunsupportedobjectstopolylines;youwouldselectNotodeclinetoconvert
theunsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedtotheSQL
ServerSpatialorSQLServerSpatialWaredatabase.
WorkingwithSQLServerwithSpatialWareTables
SpatialWareisaPitneyBowesSoftwareInc.Corporationproductthathelpsusersstore,access,
manage,andmanipulatespatialdataasastandardpartoftheirbusinessdata.Youcanqueryboth
spatialandnon-spatialdatawithinasingleSQLServerqueryusingSpatialWare.Allofthestrengths
ofSQLServerasarelationaldatabaseareextendedtospatialdatausingSpatialWare.Spatialdata
mayforexamplebedirectlymanagedandeditedbymanydifferentuserssimultaneously.
CannotUploadObject
IfyoueditamappableSpatialWaretableandtrytoinsertMapInfoEllipse,RoundedRectangle,or
Arcobjectsintoit,thefollowingmessagedisplays:
"CannotUpload.ObjectformatisnotsupportedinSpatialWare(Ellipse,RoundedRectangle,or
Arc)"
Thisisbecauseyouaretryingtoinsertobjectsthatarenotsupported.Tofixtheproblem,delete
theseobjectsfromthetableortransformthemtopolylinesorregions.Todeterminewhichobjects
havetobedeletedortransformed,runaqueryintheMapInfoSQLSelectdialogboxandspecify
"obj"intheSelectColumnclause.Theresultingquerywilltellyouthetypesofobjectsinthetable.
Selecttheobjectsyouwishtodeleteortransformanddisplaytheselectioninaneditablelayerin
aMapwindow.Todeletetheobjects,usetheClearMapObjectsOnlyoptionintheEditmenu.To
transformtheobjects,usetheConverttoRegionsorConverttoPolylinesoptionintheObjects
menu.Forbestresults,transformEllipseandRoundedRectanglesintoregions,andtransformArcs
intopolylines.
217
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
IfyoumakeaSpatialWaretablemappablewiththeObjectTypedefaultofPointandtrytoinserta
LineorRegionobjectintoit,thesamemessage"CannotUploadObjectformatisnotsupportedin
SpatialWare(Ellipse,RoundedRectangle,orArc)"displays.Thisisbecauseyouaretryingtoinsert
objectsotherthanapoint.YouneedtomakethetablemappablewiththeObjecttypespecifiedas
ALL.Tofixtheproblem,deletethetablefromtheMapCatalogusingEasyLoader.Thenre-addthe
tabletotheMapCatalogwithanObjecttypeofALLusingtheMakeTableMappableoption.
WorkingwithPostGISTables
SometimeswhenyouarecreatingamapinMapInfoProandyouarestoringtheresultsinPostGIS
youcreatemapswhichusegeometriesthatarenotsupported:PostGISdoesnotsupportarcs,
ellipses,rectangles,androundedrectangles.
IfyouhavecreatedamapyoudonotwanttolosebutcannotsavetotheDBMSofyour
choiceduetounsupportedgeometries,thenusetheSaveAsmenuoptionandsavethe
mapwithouttheunsupportedgeometries.
Note:
IfyoutrytosaveamapwithunsupportedspatialgeometrytypesinPostGIS,thesearetheresults:
•SpatialGeometryTypeswithAllUnsupportedObjects:Ifyouhavecreatedamapthatmight
containalloftheunsupportedobjectsandyouaretryingtosavetoPostGIS,thismessagedisplays:
Table has unsupported objects (rounded rectangles, ellipses or
arcs). Convert to regions and/or polylines?
ClickYestoconverttheunsupportedobjectstoregionsorpolylines;youwouldselectNotodecline
toconverttheunsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedto
thePostGISdatabase.
•SpatialGeometrytypeswithRegionObjectsOnly:Ifyouhavecreatedamapthatcontains
regionobjectsonlyandyouaretryingtosavetoPostGIS,thismessagedisplays:
Table has unsupported objects (rounded rectangles or ellipses).
Convert to regions?
ClickYestoconverttheunsupportedobjectstoregions;youwouldselectNotodeclinetoconvert
theunsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedtothePostGIS
database.
•ForSpatialGeometrytypeswithLineObjectsOnly:Ifyouhavecreatedamapthatcontains
lineobjectsonlyandyouaretryingtosavetoPostGIS,thismessagedisplays:
Arc is an unsupported object. Convert to polylines?
ClickYestoconverttheunsupportedobjectstopolylines;youwouldselectNotodeclinetoconvert
theunsupportedobjects.Ifyoudecline,youcannotsavethemapyouhavecreatedtotheSQL
ServerSpatialdatabase.
218
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
•ForSpatialGeometryoftypeRectangle:Ifyouhavecreatedamapthatcontainsrectangle
objectsandyouaretryingtosavetoPostGIS,thismessagedisplays:
Cannot upload Object - Rectangle object type is not supported in this
table. Operation canceled.
ClickOK.YoucannotsavethemapyouhavecreatedtothePostGISdatabase.
WorkingwithOracleSpatialTables
OracleSpatialisanimplementationofaspatialdatabasefromOracleCorporation.Youcaninstall
itinadditiontotheMapInfoProODBCConnectivitycomponent.Althoughithassomesimilarities
tothepreviousOracleSDOrelationalimplementation,itissignificantlydifferent.OracleSpatial
maintainstheOracleSDOimplementationviaarelationalschema.However,MapInfoProdoesnot
supporttheOracleSDOrelationalschemaviatheOracleCallInterface(OCI).MapInfoProdoes
supportsimultaneousconnectionstoOracleSpatialthroughtheOCIandtootherdatabasesthrough
ODBC.
SupportedObjectTypes
TheMultipointandCollectionobjecttypesaretranslatedintotheSpatialObjectsOracleMULTIPOINT
andCOLLECTION,respectively,viaOracleOCIandviceversa.However,Oracle'sCOLLECTION
objectisbroaderinscopethanMapInfoPro'sCollection,whichonlyallowsoneREGION,one
polylineandonemultipoint.Therefore,conversionfromMapInfoProobjecttoOracleobjectsand
theconversionfromOracleobjectstoMapInfoProobjectsmaynotbeaone-to-onetranslation.
ThefollowingtableshowstherelationshipbetweenMapInfoProobjectsandOracleobjects.
MapInfoProObjects
OracleSpatialObjects
Multipoint
MULTIPOINT
Collection
COLLECTION
Multipoint
Point(cluster)
Polyline
LineString
MultipleLineString
219
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
MapInfoProObjects
OracleSpatialObjects
REGION
Polygon
MultiplePolygons
ThetableindicateshowOracleSpatialobjectsaretranslatedintoMapInfoProobjects.Allpoint
elementsinanOracleCOLLECTIONwillbetranslatedintoonemultipointinaMapInfoProCollection;
allOracleLineobjects(includingsingleandmultiple)willbetranslatedintooneMapInfoPropolyline;
andallOraclePolygons(includingsingleandmultiple)willbetranslatedintooneMapInfoPro
REGION.Therefore,whenanOracleCOLLECTIONismodifiedandthensavedbackintoOracle
ServerbyusingMapInfoPro,theoriginalstructureoftheOracleCOLLECTIONobjectmaybe
changedifitismorecomplicatedthantheMapInfoProCollection.
IfyouareconnectingtoanOracleSpatialdatabase,OracleSpatialisanewspatialschemanumber
13.Itprovidessupportforpoints,lines,andpolygonspatialtypes.
OracleSpatialRequirements
ToconnecttoOracleSpatialwithinMapInfoPro,youmusthavetheOracleSpatialorOracle9iand
9irelease2,or10Gclientinstalled.SeeyourOracledocumentationfordetailedinformation.
PrimaryKeyusedforNewTableCreationorWhenSavingaRemoteCopy
AnUniquekeyensuresthatanentrydoesnotmatchanyotherentryfromadifferentrecord.Ifa
recorddoesnotcontainanyvalue,noerrorisreported.APrimarykeyrequiresthateveryrecord
containsauniquevalueinthatfield.BymakingthesevaluesPrimarykeys,weenforcethatevery
recordhasavalueinthisfield.
PrimaryKeyAuto-IncrementforOracleDatabases
ThePrimaryauto-incrementfeaturemanagesthePrimarykeyvalueforyou.Whenyouaddanew
recordtoaremoteOracletable,MapInfoProlocksthetable,checksforthehighestvalueofthe
Primarykeyofthetable,incrementsitbyone(1),andthenputsthatvalueinthePrimarykeyfield.
SQLServerSpatialusersdonotrequirethisfeatureastheserver-sidesoftwaremanagesthe
Primarykeyautomatically.
UsetheAutoKeycheckboxintheOpenDBMSTableOptiondialogboxtoenablethisfeature.
WhenyouselecttheAutoKeycheckbox,thePrimarykeyfieldisnoteditableandtheUniquekey
isautomaticallyincremented.Ifyoudonotselectthischeckbox,thePrimarykeyfieldremains
editable.
Toaccessthisfeature:
1. FromtheFilemenu,clickOpenandselectanOracledatabasefromtheFilesofTypedrop-down
list.ClickOKtodisplaytheOpenDBMSTableOptionsdialogbox.
2. SelecttheAutoKeyoptiontoincrementthePrimarykeyoftheselectedtableautomaticallyfor
anynewrecords.
220
MapInfoPro15.0
MapInfoProUserGuide
WorkingwithDatainaDBMS
Documents you may be interested
Documents you may be interested