Thank you everyone who replied. You've really helped me out. The reason why I wanted my x and y columns back is that I'm using a MapInfo add-on pack called Discover, and one of its functions I want to use requires access to the x and y columns.
On an unrelated note, have many people here switched to the latest version of MapInfo? I'm just curious what people think of it. I'll have to check the MapInfo website to see the new specs -- I wonder if it's worth upgrading. Regards, Michele -----Original Message----- From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED] Sent: 09 June 2006 04:34 To: Spencer Simpson; Michele Tuomi; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] DBMS Mapped Table - Dissapearing columns Another solution is to create a view in the database that has your coordinate columns twice (with different names). When you make this view mappable, MapInfo will only hide the columns used to create the point 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 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Spencer Simpson Sent: Friday, June 09, 2006 7:05 AM To: 'Michele Tuomi'; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] DBMS Mapped Table - Dissapearing columns The X and Y columns are still there; MapInfo has simply "hidden" them since it's using them for the coordinates of your points. MapInfo did this by design; it can be annoying but you have to live with it. If you want to get X and Y coordinates out of the mappable table you can still use the functions CentroidX() and CentroidY(). If you want to see coordinates in the browser, use "Pick Fields..." to add columns based on CentroidX(obj) and CentroidY(obj). Hope this helps Spencer -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michele Tuomi Sent: Thursday, June 08, 2006 4:40 PM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] DBMS Mapped Table - Dissapearing columns Hello everyone; I have an access database. There's a table in this database that I wanted to be brought into MapInfo (7.5). I've done this via the dbms connection, and created a linked table. I also wanted to make this table mappable, and have gone through the steps to do this. This table became mappable, but in the process, the table has dropped the two columns which identified the x and y coordinates. When I go into browser view to look at my table, the x and y columns aren't there. They used to be there, when the table was non-mappable. Why did this happen? How do I get my x and y columns back? Any help would be appreciated. Regards, Michele _______________________________________________ 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 _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
