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
