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'; [email protected] 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: [email protected] 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 [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
