Just stab in the dark, but what if you combined the date and time for each table into one date/time column. Then use the unique values you have just created to force a join between the tables and use the update column command. You would have to do this twice, once for the Latitude and once for the Longitudes. If you turn on your MapBasic window you will even see what code to generate in a MapBasic program. >Hey everyone,<br> ><br> >I have got a simple yet odd question for you. I have two tables: a<br> >"Navigation table" with Date, Time, Long and Lat and a "Site table" with<br> >Date, Time, and an empty Long and Lat. I want to update the Site table (Long<br> >and Lat) with the Navigation table (Long and Lat) where the Navigation.date<br> >= the Site.date and the Navigation.time = the Site.time.<br> ><br> >I know this can be easily done with the SQL select but it is really slow. If<br> >it could be done with "update column" I am sure there would be less<br> >processing time.<br> ><br> >Is this type of update column even possible?<br> ><br> >Of course, I am using MapBasic so if anyone has an example of code to help<br> >me out I would be very grateful.<br> ><br> >Thanks for your time,<br> ><br> >James Mazur<br> >GIS Telecom. Specialist<br> >Montreal, Canada<br> >[EMAIL PROTECTED]<br> ><br> ><br> ><br> ><br> >_______________________________________________________________________<br> >List hosting provided by Directions Magazine | www.directionsmag.com |<br> >To unsubscribe, send e-mail to [EMAIL PROTECTED] and<br> >put "unsubscribe MapInfo-L" in the message body.<br> ><br> _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
