RE: MI-L How to geocode table with no obvious x/y

[Terry McDonnell]

Hi Peter

Thank you very much.  I was about to do that when I got the "save query as ..." 
suggestion.  Up until today, I wasn't aware that I could do the code below cos 
I thought that my table had simply lost its graphic object/capability.  It 
would seem that it was a case of its (invisible and undetectable) objects just 
losing their values. (SIGH)

Best 

Terry

-----Original Message-----
From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED] 
Sent: 31 August 2005 15:15
To: Terry McDonnell
Subject: RE: MI-L How to geocode table with no obvious x/y

Terry,

I think what you need to do is this:

1. Make your table RouteESUMap mappable again 2. Using MapMapBasic make a loop 
that does this:

        Fetch First From RouteESUMap
        Do Until EOT(RouteESUMap)

                nRow = RouteESUMap.ROWID
                nID = RouteESUMap.esu_id

                Select * From streets
                        Where elem_unit_id = nId
                        Into STREET__CUR NoSelect

                oStreet = STREET__CUR.OBJ

                Update RouteESUMap
                        Set OBJ = oStreet
                        Where ROWID = nRow
        
                Fetch Next From RouteESUMap
        Loop


---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17689