Terry, If you could access your Visual FoxPro thru ODBC this would happen on the fly., and you would only need one copy of yoyr STOPS table - in Visual FoxPro. And I can see that there is a ODBC driver for Visual FoxPro.
Here is a short description on how to achive this: 1. Create a ODBC datasource that points to you Visual FoxPro database 2. In you Visual FoxPro database create a table called MapInfo_MapCatalog, see the MapInfo documentation for the structure. If you are lucky you could also use the tool called DBMS Catalog to create this table, but I'm not sure whether it supports VFP. 3. Open a DBMS connection to the database 4. Go to Make DBMS Tabel Mappable in the Table > Maintenance menu and select you Stops table, the columns with the coordinates and the correct coordsys. Click okay and then close. 5. Now Go to Open, as file type you select the name of your data source, and now you select your Stops table 6. The stops table should now be shown in a map HTH, Peter Horsb�ll M�ller GIS Developer 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: Terry McDonnell [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 08, 2005 2:47 PM To: [email protected] Subject: MI-L Simpleton's Question Re: Lat/Long and Object Hi List This is something I want to get to grips with. I have two versions of a Stops table: one in Visual Foxpro and the other in MI. SO, I have an VFP "Manual" database and the MI graphics version. When I make changes in either system I have the means to copy the update to the other system. Now, when I created the MI Stops table, I used the Stops' Eastings and Northings values to create the points. In my naiivity I assumed that moving a stop to a new co-ord (i.e. changing the OBJ field) would reflect itself in new E & N. But no. Changing the E & N in the manual VFP system, then copying over to the MI data DOES reflect the change in the MI N & E values, but the stop stays in the same place. i.e. the OBJ doesn't change. When I look at the values stored in these fields I notice that E & N fields -vs- X & Y points, returned by ObjectGeography(), bear no resemblance, e.g. Eastingss = 624640, Object X = 1.2607 Northings = 230917, Object Y = 51.9248 The map is based on British Co-ord system. To the point: What I want to be able to do is: if the E & N are changed manually, then I want to see the stops move to a new locn. in MI. Conversely, If I move a stop in MI, then I want its E & N to change and be detectable in the manual system. Can this be done and, if so, how? 'ppreciate it Terry --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 16728
