[MI-L] DBMS problems; making tables mappable.
Hi All, I'm having trouble mapping data from an Access 2000 database in MapInfo version 8. I have created the Map Catalogue for the DBMS connection, using the Microsoft Access .mdb machine data source and MapInfo tells me that the Catalogue item has been created successfully. Then, using the Make DBMS Table Mappable tool, I've selected the table from Access that I would like to create points from and have told MapInfo which columns I would like to use for X and Y coordinates. The columns in the Access table are set up as number; double, yet MapInfo tells me that the column 'X Coord' doesn't exist in the Access table and therefore ends the process of making the table mappable. I don't know why this happens; I've tried (in MS Access) changing the X Coord column to integer and long integer and get the same errors. The table isn't linked or anything; it was imported from an Excel spread sheet, but is now independent from it. I would be grateful for any advice on this. Best regards, Robin Smith GIS Assistant GIS team, ICT South Gloucestershire Council 01454 863407 ** This email and any files transmitted with it from South Gloucestershire Council are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the South Gloucestershire Council Postmaster at the address below. This footnote also confirms that this email message has been swept for the presence of computer viruses. [EMAIL PROTECTED] ** ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Line style problem
All, I am having trouble with a line style I am applying to the boundaries of polygons. The line style is the one where you can have small lines pointing off the main polygon boundary. I am applying the polygon styles through a thematic. The problem I am having is that for most of the polygons, the lines point into the centre of the polygon. But for a few, they point out of the polygon. Does anyone have any idea why it does this and how it can be fixed? Many thanks, James This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates Environmental Planners - Landscape Architects - Ecologists 30 Brock Street, Bath,BA1 2LN Tel: +44 (0) 1225 445548 Fax: +44 (0) 1225 312387 www.npaconsult.co.uk ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] DBMS problems; making tables mappable.
Hi, Is the name of the column "X Coord" or "X_Coord" or "XCoord" ? If the first is the name of you column, I will suggest that you rename it, so that the space is removed Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis "For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robin SmithSent: Wednesday, July 19, 2006 10:52 AMTo: mapinfo-l@lists.directionsmag.comSubject: [MI-L] DBMS problems; making tables mappable. Hi All, I'm having trouble mapping data from an Access 2000 database in MapInfo version 8. I have created the Map Catalogue for the DBMS connection, using the Microsoft Access .mdb machine data source and MapInfo tells me that the Catalogue item has been created successfully. Then, using the Make DBMS Table Mappable tool, I've selected the table from Access that I would like to create points from and have told MapInfo which columns I would like to use for X and Y coordinates. The columns in the Access table are set up as number; double, yet MapInfo tells me that the column 'X Coord' doesn't exist in the Access table and therefore ends the process of making the table mappable. I don't know why this happens; I've tried (in MS Access) changing the X Coord column to integer and long integer and get the same errors. The table isn't linked or anything; it was imported from an Excel spread sheet, but is now independent from it. I would be grateful for any advice on this. Best regards, Robin Smith GIS Assistant GIS team, ICT South Gloucestershire Council 01454 863407 ** This email and any files transmitted with it from South Gloucestershire Council are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the South Gloucestershire Council Postmaster at the address below. This footnote also confirms that this email message has been swept for the presence of computer viruses. [EMAIL PROTECTED] ** ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] Line style problem
This can happen if some of the polygons are drawn clockwise and some anticlockwise. As far as I know, you'd need to convert the polygons to polylines, then reverse their direction. Yours, Martin Spiers Senior Engineer MWH Kenburgh House, Manor Row, Bradford BD1 4QU Tel: 01274 718786 Fax: 01274 718799 email: [EMAIL PROTECTED] ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Problem with parameters in Sub
Hi, I'm having some difficulty passing parameters in a Sub procedure. The MapBasic help gives the following as a example of using a sub procedure. It includes a value "2" as a parameter. Declare Sub Cube(ByVal original As Float, cubed As Float) . . Call Cube( 2, result) I've adapted this to pass some text values for a table name and some column titles: Declare Sub Table_to_Array( byval sTabname as string, sCol_1 as string, sCol_2 as string, sType as string) . . Call Table_to_Array("T_Usrn", "street_text", "street_reference_number", "Streets") The outcome is an error on compilation stating: Found [street_text] while searching for [An identifier] Where am I going wrong? Thanks Ian ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] re-order map layers
Title: Message Hi I have one Map with five layers Does a simple way exist to make the third layer the toplevel layer ? (by this way the firt layer becomes the second, the second layer becomes the third, and so on...) Thank you Chris ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
SV: [MI-L] Problem with parameters in Sub
Title: Meddelelse Hi Ian, You have to write ByVal before each variable /parameter definition in order to pass text strings to the sub. Furthermore you have the possibility to write several parameters of the same type before declaring the variable type i.e.: Declare Sub Table_to_Array( byval sTabname, byval sCol_1, byval sCol_2, byval sType as string) Best regardsJacob K. JørgensenEngineer, M.SC. in GeoInformatics__WatertechSoendergade 53DK-8000 Aarhus CPhone: +45 8732 2020Direct phone: +45 8732 2078Fax: +45 8732 2021[EMAIL PROTECTED]www.watertech.dk -Oprindelig meddelelse-Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne af Ian RobertsonSendt: 19. juli 2006 13:28Til: MapInfo-L@lists.directionsmag.comEmne: [MI-L] Problem with parameters in Sub Hi, I'm having some difficulty passing parameters in a Sub procedure. The MapBasic help gives the following as a example of using a sub procedure. It includes a value "2" as a parameter. Declare Sub Cube(ByVal original As Float, cubed As Float) . . Call Cube( 2, result) I've adapted this to pass some text values for a table name and some column titles: Declare Sub Table_to_Array( byval sTabname as string, sCol_1 as string, sCol_2 as string, sType as string) . . Call Table_to_Array("T_Usrn", "street_text", "street_reference_number", "Streets") The outcome is an error on compilation stating: Found [street_text] while searching for [An identifier] Where am I going wrong? Thanks Ian ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] Problem with parameters in Sub
When you pass a constant, you have to use the ByVal declaration. So your subroutine must be declared as: Declare Sub Table_to_Array( byval sTabname as string, ByVal sCol_1 as string, ByVal sCol_2 as string, ByVal sType as string) On Wed, Jul 19, 2006 at 12:28:08PM +0100, Ian Robertson wrote: > Hi, > > I'm having some difficulty passing parameters in a Sub procedure. > > The MapBasic help gives the following as a example of using a sub procedure. > It includes a value "2" as a parameter. > Declare Sub Cube(ByVal original As Float, cubed As Float) > . > . > Call Cube( 2, result) > > > I've adapted this to pass some text values for a table name and some column > titles: > > Declare Sub Table_to_Array( byval sTabname as string, sCol_1 as string, > sCol_2 as string, sType as string) > . > . > Call Table_to_Array("T_Usrn", "street_text", "street_reference_number", > "Streets") > > The outcome is an error on compilation stating: > Found [street_text] while searching for [An identifier] > > > Where am I going wrong? > > Thanks > > Ian > > > > ___ > MapInfo-L mailing list > MapInfo-L@lists.directionsmag.com > http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] re-order map layers
The command is: Set Map Order 3 On Wed, Jul 19, 2006 at 02:06:46PM +0200, Christophe Brabant wrote: > Hi > > I have one Map with five layers > > Does a simple way exist to make the third layer the toplevel layer ? (by > this way the firt layer becomes the second, the second layer becomes the > third, and so on...) > > Thank you > > Chris > ___ > MapInfo-L mailing list > MapInfo-L@lists.directionsmag.com > http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] MapInfo position available - Washington DC metro area
Large, national shopping center developer, owner and manager seeks experienced MapInfo user for a marketing position in their Northern Virginia office. Please email me outlining your MapInfo experience. Thank you. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Combine objects as a query
Hi list, is it able to combine objects remaining the result as a query, not as a table? thank you Sergi Gàmiz Ribelles (627481954) REGS DE CATALUNYA S.A. (www.regsa.es) Unitat de Promoció de Regadius i Concentració Parcel·lària c/General Brito, 6, 5è 25007 Lleida tel. 973222838 fax 973222627 [EMAIL PROTECTED] ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] About Geodatabase
Hi again, I need to select entities prior to load them from a larg table. When those objects are just alfanumerics I use a DBMS connection, so appears a dialog where i can customize the filter conditions. But when those objects are features (shapes and lines, etc), I don't know how to filter them before to load them. * I've been told to investigate about Geodatabases. Which and how can I use? * I've gotten an client Oracle driver for MIpr; is it useful for me? * There is an Informix driver within the MapInfo original installation CD; is this something usefull for my purposes? Thank very much in advance Sergi Gàmiz Ribelles (627481954) REGS DE CATALUNYA S.A. (www.regsa.es) Unitat de Promoció de Regadius i Concentració Parcel·lària c/General Brito, 6, 5è 25007 Lleida tel. 973222838 fax 973222627 [EMAIL PROTECTED] ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] RE: Wrong Symbols
Hi, This may be an easy fix but we are having trouble opening up symbols in our maps. The symbols are suppose to be "stars" but they show up on mine as a triangle and another computer they show up as a circle. We're using the Mapinfo 3.0 compatible symbols. Any ideas? Mark Market Research Analyst ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l