1) Add additional column to Streets table - e.g. TempFrom
2) Select all reversed streets - let us call temporary query table
ReversedStreets
3) Update ReversedStreets Set TempFrom = From
4) Update ReversedStreets Set From = To
5) Update ReversedStreets Set To = TempFrom
6) Drop TempFrom column from Streets table
Lena Bagh
> Is there any way to swap the values in one column with the values of
> another? I have a huge street file database and the "to" and "from" values
> for some of the streets are reversed. Besides selecting the streets in
> question, deleting them from the original table and just changing the
column
> heading and order of the selection and then dumping them back into the
> original table, is there a simpler way??
>
> Thanks
>
> Steve
>
>
>
> _______________________________________________________________________
> 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.
>
>
_______________________________________________________________________
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.