pdf reader c# : How to delete text from pdf reader application Library tool html asp.net winforms online MapInfoProfessionalUserGuide17-part749

CreatingaDataSourceConnectiontoOracle
Beforeyoubegin,youwillneedthefollowinginstalledonyourmachine:
• OracleClient-connectstoanOracledatabase.
• TCP\IP-acommunicationsprotocolrequiredbyOracleClienttocommunicateonthenetwork
• OracleSQL*Net-forperformingSQLqueriestothedatabase(optional).
Haveyourdatabaseadministratorcheckthatthe:
• tnsnames.orafileiscorrectlyconfiguredonyourmachinefortheserveryouwanttoconnectto.
• Servicetothedatabaseisconfigured-theymayneedtoruntheNetConfigurationAssistantutilitythat
Oracleprovidestoconfiguretheservice.
• TCP\IPworkingproperly(usingping.exe).
• EnvironmentvariableTNS_ADMINiscorrectlysettoyourclient_1path(theOracleClientinstallation
directory).
TocreateanewOracleSpatialdatasourceconnection,setupyourOracleDriver:
1. OntheStartmenu,pointtoAllPrograms,clickOracle...,clickConfigurationandMigrationTools,
andthenclickMicrosoftODBCAdministrator.
2. IntheODBCDataSourceAdministrator,undertheUserDSNtab,clickAdd.
3. IntheCreateNewDataSourcewizard:
a. Fromthedrivernamelist,selecttheOracleinOraClientdriverandthenclickNext.
b. ClickFinishtoinstallthedriver.
4. IntheODBCTextSetupdialogbox,setthefollowing:
• DataSourceName-Provideanameforthisdatasource.Thisisthenameyouwillseeafter
settingupthisconnectionintheSelectDataSourcedialogbox.
• Description-Optionally,typeadescriptionifyouplanonconnectingtomorethanonedatabase
andwouldlikeadescriptionforthisconnection.
ClickOK.
TosetupyourOracleSpatialconnectioninMapInfoProfessional:
1. FromtheFilemenu,selectOpenDBMSConnection.
2. IntheOpenDBMSConnectiondialogbox,selectOracleSpatialfromthelistandthenclickNew.
3. IntheMapInfoOracleConnectdialogboxenterthefollowinginformation:
• UserName-Theusernameforaccessingthedatabase.
• Password-Thepasswordforaccessingthedatabase.
• ServerName-ThenameoftheOracledatabasethatyouwanttoconnectto.
Optionally,checktheUseOperatingSystemAuthenticationcheckboxtouseyourWindows
authenticationwhenaccessingthisOracledatabase.
ClickOK.
YouhaveanactiveconnectiontoyourOracledatabase.Youmustnowcreateamapcatalogforthe
database,continuetoCreatingaMapCatalogTableUsingEasyLoader.
IntheMapInfoOracleConnectdialogbox,youhavetheoptiontochecktheUseOperatingSystem
Authenticationcheckbox.WithOSauthentication,yourdatabasereliesontheunderlyingoperating
systemtorestrictaccesstodatabaseaccounts.Adatabasepasswordisnotusedforthistypeoflogin.
Foradditionalinformation,refertoOracleOperatingSystemAuthenticationandConfiguration.
171
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
How to delete text from pdf reader - 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
erase text in pdf document; how to delete text in pdf converter
How to delete text from pdf reader - 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 in pdf file online; acrobat delete text in pdf
CreatingaDataSourceConnectiontoMicrosoftAccess
YoucanworkwithyourMicrosoftAccessdatabasefromMapInfoProfessionalthroughanODBC
connection.MicrosoftAccessdoesnotallowspatialdata,butyoucandisplayinMapInfoProfessional
datathathasXandYcoordinatevaluesassociatedwithit.
BeforeyouBegin
Beforeyoubegin,youmusthavetheMicrosoftAccessDriverinstalledonyourmachine-thedriveris
installedbydefaultwithyourMicrosoftAccess.ThedriverisnecessaryforestablishinganODBC
connectiontothedatasource.
Tocheckthatthedriverisinstalledonyourmachine,runtheODBCAdministrator:
1. OpentheControlPanel;fromtheStartmenuselectControlPanel.
2. IntheControlPanel,intheClassicView,selectAdministrativeToolsandthenDataSources
ODBC(ODBC).
3. IntheDataSourcesODBCAdministratordialogbox,selecttheUserDSNtab.
4. Inthelist,locateandselecttheMSAccessDatabase.Or,ifyoudonotseethisname,thenunder
theDriverlistlookforMicrosoftAccessDriver(.mdbor.accdb).
5. ClickConfiguretoensurethatitisproperlysetup.
Ifthedriverisnotthere,thenclickAddtocheckiftheAccessdriverisinstalled.Youmayneedtoinstall
theMicrosoftAccessdrivers.TheseareincludedwithMicrosoftAccess,MicrosoftOfficeProfessional,
ODBCSDK,VisualC++,MapInfoProfessional,orpurchasedseparately.
Toverifyifthisistherequiredversionofthisdriver,selecttheDriverstabintheODBCAdministrator.
LocatetheMSAccessDriver(.MDBor.ACCDB)andcheckthatitisthelatestversion.
ToaddanewMicrosoftAccessDataSource:
1. RuntheODBCAdministrator.
2. UndertheUserDSNtab,clickAdd.
3. IntheCreateNewDataSourcewizard,selectMSAccessDriver(.MDBor.ACCDB)fromthelist
andclickFinish.
4. IntheODBCMicrosoftAccessSetupdialogbox,intheDataSourceNamebox,typeinaname
forthedatasource.(ThisisthenamethatappearsinthelistwhenyouconnectfromMapInfo
Professional.)ClickSelect.
5. IntheSelectDatabasedialogbox,selecttheMicrosoftAccessdatabaseyouwishtouseandthen
clickOK.
Ifyoudonotselectadatabaseforthisdatasource,apromptdisplaysduringtheconnectiontodo
so.MapInfoProfessionalprovidesasampleMicrosoftAccessdatabase.
Limitation
inMicrosoftAccess,ifthekeyissettocharacter,thenitdoesnotdisplayrowswhenthekeyvalueis
lessthanthefullcolumnwidth:forexample,ifthekeyissettochar(5),thenthevalue`aaaa'lookslike
adeletedrow.
ReconnectingtoyourDataSourceafterStartup
EachtimeyoustartMapInfoProfessional,youmustsettheconnectiontoyourdatabasebeforeyoucan
workwithtables.TheconnectionremainsactivewhileMapInfoProfessionalisopen.Theconnection
closeswhenyouexitMapInfoProfessional.
ThefollowinginstructionsareapplicabletoSQLServerandPostGISusers.Oracleusers,seeConnecting
toOracleafterRe-StartingMapInfoProfessional.
MapInfoProfessional12.5
172
ReconnectingtoyourDataSourceafterStartup
VB.NET PDF Page Delete Library: remove PDF pages in vb.net, ASP.
›› VB.NET PDF: Delete PDF Page. 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.
how to copy text out of a pdf; pdf text remover
C# PDF Page Delete Library: remove PDF pages in C#.net, ASP.NET
Page: Delete Existing PDF Pages. |. Home ›› XDoc.PDF ›› C# PDF: Delete PDF Page. C#.NET PDF Library - Delete PDF Document Page in C#.NET.
delete text pdf acrobat; how to erase text in pdf
Toopenaconnectiontoyourdatabase:
1. FromtheFilemenu,selectOpenDBMSConnection.
2. IftheOpenDBMSConnectiondialogboxdisplays,selectODBCfromthelistandthenclickNew.
3. IntheSelectDataSourcedialogbox:
a. SelecttheMachineDataSourcetab.
b. FromtheDataSourcenamelist,selectyourconnectionname.
c. ClickOK.
Youmayseealogindialogboxforyourdatabaseconnection.Ifyouseethisdialog,thenprovide
theinformationrequired,suchasusernameandpasswordforthedatabase.Forexample,SQL
Serverusersmayseethefollowing:
Youarenowreadytoopenatable.Todothis,selectFile>OpenandthenfromtheFilesoftypelist,
selectyourdatasourcenamefromthelisttodisplaythetableinyourdatabase.
ConnectingandOpeningaTableattheSameTime
Toopenaconnectiontoyourdatabaseandthenopenatableinthedatabase:
1. FromtheFilemenu,selectOpen.
2. IntheOpendialogbox,selecttheOpenDBMSConnection
button.
3. IftheOpenDBMSConnectiondialogboxdisplays,selectODBCfromthelistandthenclickNew.
4. IntheSelectDataSourcedialogbox:
a. SelecttheMachineDataSourcetab.
b. FromtheDataSourcenamelist,selectyourconnectionname.
c. ClickOK.
Youmayseealogindialogboxforyourdatabaseconnection.Ifyouseethisdialog,thenprovide
theinformationrequired,suchasusernameandpasswordforthedatabase.Forexample,SQL
Serverusersmayseethefollowing:
173
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
VB.NET PDF Text Extract Library: extract text content from PDF
PDF ›› VB.NET PDF: Extract PDF Text. VB.NET PDF - Extract Text from PDF Using VB. How to Extract Text from PDF with VB.NET Sample Codes in .NET Application.
acrobat remove text from pdf; how to remove highlighted text in pdf
C# PDF Text Extract Library: extract text content from PDF file in
XDoc.PDF ›› C# PDF: Extract PDF Text. C# PDF - Extract Text from PDF in C#.NET. Feel Free to Extract Text from PDF Page, Page Region or the Whole PDF File.
how to delete text from pdf; pull text out of pdf
5. IntheOpendialogboxschemaandtablesinyourdatabasedisplay.Ifyoudonotseethis,thenfrom
theFilesoftypelist,selectyourdatasourcename.
SelectthetabletoopenfromthelistandclickOpen.
Youarenowreadytoworkwithyourtable.
ConnectingtoOracleafterRe-StartingMapInfoProfessional
ToopenaconnectiontoyourOracledatabase:
1. FromtheFilemenu,selectOpenDBMSConnection.
2. IntheOpenDBMSConnectiondialogbox,selectOracleSpatialfromthelistandthenclickNew.
3. IntheMapInfoOracleConnectdialogboxenterthefollowinginformation:
• UserName-Theusernameforaccessingthedatabase.
• Password-Thepasswordforaccessingthedatabase.
• ServerName-ThenameoftheOracledatabasethatyouwanttoconnectto.
ClickOK.
Youarenowreadytoopenatable.Todothis,selectFile>OpenandthenfromtheFilesoftypelist,
selectOracletodisplaythetableinyourOracledatabase.
ConnectingtoOracleandOpeningaTableattheSameTime
ToopenaconnectiontoyourOracledatabaseandthenopenatableinthedatabase:
1. FromtheFilemenu,selectOpen.
2. IntheOpendialogbox,selecttheOpenDBMSConnection
button.
3. IntheOpenDBMSConnectiondialogbox,selectOracleSpatialfromthelistandthenclickNew.
4. IntheMapInfoOracleConnectdialogbox:
• UserName-Theusernameforaccessingthedatabase.
• Password-Thepasswordforaccessingthedatabase.
• ServerName-ThenameoftheOracledatabasethatyouwanttoconnectto.
ClickOK.
5. IntheOpendialogboxschemaandtablesinyourOracledatabasedisplay.Ifyoudonotseethis,
thenfromtheFilesoftypelist,selectOracleoryourdatasourcename.
SelectthetabletoopenfromthelistandclickOpen.
YouarenowreadytoworkwithyourOracletable.
MapInfoProfessional12.5
174
ReconnectingtoyourDataSourceafterStartup
C# PDF insert text Library: insert text into PDF content in C#.net
Supports adding text to PDF in preview without adobe reader installed in ASP.NET. Powerful .NET PDF edit control allows modify existing scanned PDF text.
pdf text remover; remove text from pdf
C# PDF Text Search Library: search text inside PDF file in C#.net
Text: Search Text in PDF. C# Guide about How to Search Text in PDF Document and Obtain Text Content and Location Information with .NET PDF Control.
delete text pdf acrobat professional; how to erase pdf text
About SupportedDBMS DataTypes
ThissectionprovidesalistofsupporteddatatypesandanydatarestrictionsforSQLServer,PostGIS,
andOracle.
SQLServerDataSupport
Read-OnlySupportforSpatialObjectsinSQLServerwithZandMValues
SpatialdatathatisstoredinSQLServerSpatialGeometryandGeographyfieldtypesmayhaveZand
Mvalues.MapInfoProfessionalcannoteditthistypeofspatialdataandignorestheZandMvalues,so
youmustviewthesetablesasread-onlyinMapInfoProfessional.Ifyoueditthistypeofspatialdatain
MapInfoProfessional,savingthetablebacktotheoriginalSQLServerSpatialtabledoesnotpreserve
theoriginalZandMvalues.
TheMapInfo_MapCataloghasthefollowingspatialtypesfortableswithZandMvalues:
20-Geometryread-onlysupportofobjectswithZ/Mvalues.
21-Geographyread-onlysupportofobjectswithZ/Mvalues
SupportedSQLServerODBCDataTypes
ThesearetheODBCdatatypesthatMapInfoProfessionalsupports:
• SQL_BIT
• SQL_TINYINT
• SQL_SMALLINT
• SQL_INTEGER:
• SQL_REAL
• SQL_BIGINT
• SQL_DECIMAL
• SQL_DOUBLE
• SQL_FLOAT
• SQL_NUMERIC
• SQL_BINARY
• SQL_LONGVARBINARY
• SQL_VARBINARY
• SQL_LONGVARCHAR
• SQL_DATE
• SQL_TYPE_DATE
• SQL_TIMESTAMP
• SQL_TYPE_TIMESTAMP
• SQL_TIME
• SQL_TYPE_TIME
• SQL_CHAR
• SQL_VARCHAR
PostGISDataSupport
SupportedPostGISColumnTypes
MapInfoProfessionalsupportsalldatatypes.PleasenotethatPostGISiscasesensitive.
175
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
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;
delete text from pdf acrobat; acrobat delete text in pdf
C# PDF metadata Library: add, remove, update PDF metadata in C#.
Allow C# Developers to Read, Add, Edit, Update and Delete PDF Metadata in .NET Project. Remove and delete metadata from PDF file.
how to erase text in pdf; deleting text from a pdf
OracleDataSupport
WorkingwithOracleSpatialData
MapInfoProfessionalusesOracleSpatialforOracletables(XYissupportedviaOCI).MapInfo
ProfessionaldoesnotsupportHH_CODE(andtheoldversionofSDOindextypes).
SupportedOracleDataTypes
Thefollowinglistsnon-spatialdatatypesfromOracleSpatialandwhattheyaretreatedasinMapInfo
Professional:
toMapInfoProfessional
FromOracle
BinaryStringupto127bytesshownasHex
characters
RAW,LONGRAW
MIObject
Namedtype
MIObject
NamedObjecttype(SDO_GEOM)
NotSupported
BLOB,CLOB
Character
CHAR,VARCHAR,LONG,LONGVARCHAR
ifnoscaleorprecision:FloatelseDecimal
Number,Decimal
Integer
INTEGER
Float
FLOAT
Date
DATE
MapInfoProfessionalcapturesmanyOracledatatypesandtranslatesthemintoMapInfonativetypes.
Whenthecolumnisupdated,Oracledatamakessurethatthedatabeingboundistranslatedintothe
columnformat(forexample,MapInfoProfessionalcanbindacharacterasalongandsenditthrough
toOracleandontheotherenditwillbetranslatedintoalongnumberinthetable).
SpatialObjectTypesfromOracleSpatialtoMapInfoProfessional
toMapInfoProfessional
FromOracle:GTYPES
NULL
0UNKNOWN_GEOMETRY(Spatialignoresthis
geometry.)
Point
1POINTGeometrycontainsonepoint.
Line(ifonly2pts)orPolylineif>2pts)
2LINESTRINGGeometrycontainsonelinestring.
Region
3POLYGONGeometrycontainsonepolygon.
Collection
4CollectionGeometryisaheterogeneous
collectionofelements.
MultiPoint
5MULTIPOINTGeometryhasmultiplepoints.
Region
6MULTILINESTRINGGeometryhasmultipleline
strings.Poly-line
MapInfoProfessional12.5
176
AboutSupportedDBMSDataTypes
toMapInfoProfessional
FromOracle:GTYPES
Region
7MULTIPOLYGONGeometryhasmultiple
polygons(morethanoneexteriorboundary).
GeometryConversionsfromOracleSpatialtoMapInfoProfessional
ThefollowinglistsOracleSpatialgeometrytypesandwhattheyconverttoinMapInfoProfessional.
Comments
Converted
to
MapInfo
Type
GeometryType
CircularArcsaremadeupofthreecoordinates,starting
point,anypointonthearc,andendingpoint.MapInfo
Polyline
CircularArc
Professionalwillusethesethreepointstoformapolyline
representingthearc.
Circlesaremadeupofthreecoordinatesonthe
circumferenceofthecircle.MapInfoProfessionalwilluse
thesethreepointstoformacircularregion.
Region
Circle
Region
Rectangle
Multipoint
MULTIPOINT
Collection
{Multipoint,
COLLECTION{Point(cluster),
LineString,MultipleLineString,
Polygon,MultiplePolygon}
Polyline,
Region}
Oraclecurrentlydoesnothaveamechanismtocheck
thevalidityofobjects.MapInfoProfessionalwillperform
Unknownorinvalidgeometries
oruserdefined.
somegeometrychecks.IfMapInfoProfessionaldetects
aninvalidoranunknowngeometry,itwillreturnanull
objecttopreventerrors.Noerrormessagewilldisplay
tonotifyusersofthenullgeometries.
MapInfoProfessionalcandownloadsomeorallofanOracleSpatialtablethrougheitheraspatialquery
orattributequery.
ToselectaMultipointobjectwithinaregion(forexample,SelectObjectwithinSelection),the
firstpointoftheMultipointobjectmustbewithintheregion.Otherwise,theSelectstatementfails.
Note:
ThesameruleappliestoCollectionscontainingMultipointobjects.LinesandPolygonsin
Collectionsshouldworkcorrectly.
CreatingaMap CatalogintheDBMS toWorkwith
Data
MapInfoProfessionalstoresinformationaboutspatialtablesandviewsinthedatabase.Itstoresthis
informationinafilecalledMAPINFO.MAPINFO_MAPCATALOG(theMapCatalog)asaspecialtable
ontheDBMSyouareaccessing.
177
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
TheMAPINFO_MAPCATALOGisaregistrytablefordatabasesthatstoresmetadataaboutspatialtables
andviewsinthedatabase.Usingthetablenameandownernameasthekey,the
MAPINFO_MAPCATALOGidentifiesthespatialtype,spatialcolumns(ifthereismorethanone),
projection,databounds,andrenditioninformation.TheMAPINFO_MAPCATALOGisusedbyanumber
ofMapInfoproducts,includingMapInfoProfessional,thataccessmapdatafromdatabases.
Theremustbeonecatalogperdatabase,whichisrequiredbeforemappinganytablesonthatdatabase
inMapInfoProfessional.
BeforeyouBeginCreatingaMapCatalogTable
YouwilluseEasyLoadertocreateaMapCatalogtableinthedatabaseyouwishtoworkwith.EasyLoader
installswithMapInfoProfessional.
EasyLoaderisalsoavailableasafreedownloadfromthePitneyBowesSoftwarewebsite.Ifyou
downloadacopyofEasyLoader,thenyoumustensurethatyouhavethesameversionof
EasyLoaderasMapInfoProfessionaltousethemtogether.
Note:
Beforeyoubegin,youmustalertyourdatabaseadministratortothefollowing:
• Yourequireadministratorprivilegestoreadandwritetothedatabaseserver.Evenifyouonlyread
tablesontheserver,youstillrequirewriteaccesstohaveEasyLoadercreateandthenhaveMapInfo
ProfessionalwritetotheMapCatalogtable.
• EasyLoadercreatesaMAPINFOschemaattheserverlevelwhilecreatingtheMapCatalogtable.
• EasyLoadercreatesaMAPINFOuserforthedatabase.
Yourdatabaseadministratormaywanttomanuallysetupyourdatabaseaccess,thusbypassingthe
needtouseEasyLoader.IfyourdatabaseadministratorwantstocreatetheMapCatalogtablemanually.
InstructionsareavailableintheMapInfoProfessionalHelpSystemunderManuallyCreatinga
MapInfo_MapCatalog.
CreatingaMapCatalogTableUsingEasyLoader
EasyLoaderinstallswithMapInfoProfessionalasatool,butyoucanrunitseparatlyfromMapInfo
Professional.Itletsyoucreateadatasourceconnectionandcreateamapcataloginthedatabase.
TocreateaMapCatalogtableusingEasyLoader:
1. LoadEasyLoaderasatoolinMapInfoProfessional:
a. OntheToolsmenu,clickToolManager.
b. IntheToolManagerdialogbox,selecttheLoadedcheckboxnexttotheEasyLoadertool.
TohavethetoolloadautomaticallyeverytimeyoustartMapInfoProfessional,selecttheAutoload
checkboxnexttothetool.
c. ClickOK.
2. RunEasyLoaderfromtheToolsmenu,selectTools>EasyLoader>EasyLoader.
EasyLoaderopens,proceedtothefollowingsectionthatappliestoyou.
SQLServerandPostGISusers:
1. ClickODBC.IntheSelectDataSourcedialogbox,selecttheMachineDataSourcetab.Fromthe
DataSourcenamelist,selectyourconnectionname,andclickOK.
Youmayseealogindialogboxforyourdatabaseconnection.Ifyouseethisdialog,thenprovide
theinformationrequired,suchasusernameandpasswordforthedatabase.
2. ClickMapCatalogtoaddanewMapCatalog.Oneoftwothingshappens:
MapInfoProfessional12.5
178
CreatingaMapCatalogintheDBMStoWorkwithData
IfthereisnoMapCatalogavailableforthecurrentdatabase,EasyLoadercreatesaMAPINFO
userifonedoesnotalreadyexistandthencreatestheMapCatalog.ThisconcludestheMap
Catalogcreationprocess.
• IfthereisaMapCatalog,theUnregistertablesfromMapCatalogdialogboxdisplays.Close
thisdialogbox.Thereisalreadyamapcataloginthisdatabase.
IftheMapCatalogispresentandtherearenoentriesinit,thentheMapCatalogbutton
doesnotenable.
Note:
3. ClickClosetocloseEasyLoader.
Oracleusers:
1. ClickOracleSpatial.IntheMapInfoOracleConnectdialogboxsetthefollowingandthenclickOK:
• UserName-Theusernameforaccessingthedatabase.
• Password-Thepasswordforaccessingthedatabase.
• ServerName-ThenameoftheOracledatabasethatyouwanttoconnectto.
2. ClickMapCatalogtoaddanewMapCatalog.Oneoftwothingshappens:
• IfthereisnoMapCatalogavailableforthecurrentdatabase,EasyLoadercreatesaMAPINFO
userifonedoesnotalreadyexistandthencreatestheMapCatalog.ThisconcludestheMap
Catalogcreationprocess.
• IfthereisaMapCatalog,theUnregistertablesfromMapCatalogdialogboxdisplays.Close
thisdialogbox.Thereisalreadyamapcataloginthisdatabase.
IftheMapCatalogispresentandtherearenoentriesinit,thentheMapCatalogbutton
doesnotenable.
Note:
3. ClickClosetocloseEasyLoader.
AddingaSpatialPrimaryKeytoaDBMS Table
AfterestablishingadatasourceconnectiontoyourDBMSyoumustaddageometryreferencetothe
tablesyouwishtoworkwithonamapinMapInfoProfessional.Eachtablethatyouwanttoworkwith
mustcontaingeometry,suchasregions,orX,Ypointdata,withcorrectlynamedcolumnsandaunique
primarykeycolumnthatisindexedanddefinedwithaspecificname.
IfyouattempttoworkwithaDBMStablethatdoesnotcontainaspatialprimarykeycolumnanddoes
nothavegeometryandX,Ycolumnscorrectlylabeled,thenyoumayseethefollowingerror:
UnabletodownloadonlytheOBJECTfromaDBMStable.Selectanadditionalattributecolumn.
TohaveMapInfoProfessionalprepareatableforyou:
1. OpenthetableinMapInfoProfessional,selectFile>Openandthenlocateandselectthetablefrom
theOpendialogbox.
2. SelectFile>SaveCopyAsandsaveacopybacktotheDBMS.
Thissavesacopyofthetablewithauniqueprimarykeycolumnthatisindexedandinthecorrect
format.ThisprocessalsoasksyouforyourspatialgeometrycolumnoryourX,Ycolumnsinthetable
andthenrenamesthesecolumns,sothatMapInfoProfessionalcanworkwiththem.
YouarenowreadytobeginworkingwiththedatainMapInfoProfessionalintabularform(inaBrowser
window).Fordetailsonwhatchangesaremadetocolumnnames,seeAddingaSpatialPrimaryKey
Manually.
179
MapInfoProfessionalUserGuide
Chapter7:WorkingwithDatainaDBMS
IfyouwanttoconvertyourtabletotheMapInfoProfessionalnative.TABformattoworkwithit,thenuse
EasyLoader,whichwillalsorenameyourgeometryorpointcolumnsandaddaspatialprimarykey
columntothetable.
AddingaSpatialPrimaryKeyManually
Tohavefullcontroloverrenaminggeometryorpointcolumnsandaddaspatialprimarykeycolumnto
oneormoretables,youcandothismanually.Ifyouchoosetoupdateyourtablesyourself,thenyou
mustmakethefollowingchanges:
GeometryDataTables
Ifyouareworkingwithaspatialtablecontaininggeometry(suchasregions),thegeometrycolumnmust
benamedSP_GEOMETRY.Thefollowingtableisasummaryofwhatisrequiredforgeometrydata
tables(notethatMicrosoftAccessdoesnotsupportgeometrydata,onlypointdata):
GeometryColumnName
PrimaryKeyColumn
DBMSorDataSource
SP_GEOMETRY
MI_PRINX
Oracle,PostGIS,SQLServer
Spatial
• Ifworkingwithadatabasetable,thenMapInfoProfessionalfindsthecorrectprimaryindexcolumn
(thiscolumnmustbeanumerictype).
• Ifworkingwithadatabaseview,thenitmusthaveacolumnnamedMI_PRINXthatisuniqueand
numeric.
X,YPointDataTables
IfyouareworkingwithaspatialtablecontainingX,Ydata(suchasLatitudeandLongitude),theXand
YcolumnsmustbenamedMI_SQL_XandMI_SQL_Y.Thetablemustalsohaveauniqueprimarykey
columnthatisindexedandnamedMI_SQL_REC_NUM.
YColumnName
XColumnName
PrimaryKeyColumn
DBMSorDataSource
MI_SQL_Y
MI_SQL_X
MI_SQL_REC_NUM
Access,Oracle,
PostGIS,SQLServer
Spatial,SQLServerwith
SpatialWare
Tousedifferentnamesforthesecolumns,specifythenameoftheX,Yandspatialobjectcolumnsin
theMapCatalog.
SQLServerwithSpatialWareTables
IfyouareworkingwithSQLServerwithSpatialWareinstalled,thecolumnnamingconventionisdifferent
fromotherspatialDBMStables.YoumustuseSW_MEMBERfortheuniqueprimarykeycolumnthat
isindexed,andSW_GEOMETRYforthegeometrycolumn.
GeometryColumnName
PrimaryKeyColumn
DBMSorDataSource
SW_GEOMETRY
SW_MEMBER
SQLServerwithSpatialWare
IfyourtablecontainsX,Ydata,thenthecolumnnamesmustbeMI_SQL_XandMI_SQL_Y.
MapInfoProfessional12.5
180
AddingaSpatialPrimaryKeytoaDBMSTable
Documents you may be interested
Documents you may be interested