Are you using "File->Save Copy As..." Or "file -> Save Query As"? The former should always work the way you describe.
Before you delete you original table make sure all of the records are represented in the new table. Spencer -----Original Message----- From: Terry McDonnell [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 31, 2005 8:10 AM To: [email protected] Subject: RE: MI-L How to geocode table with no obvious x/y Thanks Uffe, Martin and Søren As you all suggested (together :-), I've changed the order and I do indeed get a cursor with graphical objects, and I can display the polylines as a map of the plotted bus routes. So far so good BUT: - I really wanted my original table, "RouteESUMap", to have the mappable objects. - I try to save the cursor to RouteESUMap but I can't, because RouteESUMap is still open. - so I close RouteESUMap, but now the cursor/view created, busroutes_map has gone with it. - so I redo the select etc. and save the cursor/view as "RouteESUMap2" - I then open RouteESUMap2, expecting to see my streets BUT - no objects to view, just like RouteESUMap - back to square one! It's all very frustrating. Any more ideas I really do appreciate your help here, guys! Terry -----Original Message----- From: Uffe Kousgaard [mailto:[EMAIL PROTECTED] Sent: 31 August 2005 12:01 To: Terry McDonnell Subject: Re: MI-L How to geocode table with no obvious x/y If table streets is the one with a geographic object, it has to be the first in the "from"-part of the query. As Martin Spears had also done :-) ----- Original Message ----- From: "Terry McDonnell" <[EMAIL PROTECTED]> To: "Martin A Spiers" <[EMAIL PROTECTED]>; <[email protected]> Sent: Wednesday, August 31, 2005 12:33 PM Subject: RE: MI-L How to geocode table with no obvious x/y Hi Martin Thanks very much for the reply. I tried: Select Rte_No, Gen, Directn, esu_id, elem_unit_id from RouteESUMap, streets where streets.elem_unit_id = RouteESUMap.esu_id into busroutes_map Map From busroutes_map I think that's as near as I can get to your example. But all I got was a non-mappable cursor, practically identical to the original RouteESUMap, with no graphics. Am I missing something here, or have you any other ideas. Yours gratefully Terry -----Original Message----- From: Martin A Spiers [mailto:[EMAIL PROTECTED] Sent: 30 August 2005 16:45 To: Terry McDonnell Subject: Re: MI-L How to geocode table with no obvious x/y I'm not sue you need the x/y coordinates of the bus route segments. If table "busroutes.tab" is as described and table "streets.tab" contains a graphical object for each ESU then these can be linked by the ESU then something like Select busroutes.bus_route_id, streets.esu_id from streets, busroutes where streets.esu_id=busroutes.esu_id into busroutes_map Map From busroutes_map will produce a new, mappable table with the same fields as the original "busroutes.tab" and the graphics from streets.tab Hope this helps --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17680 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17682 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17684
