Scott,
If your points have unique numeric IDs and your line table defines each
connection in terms of those IDs, then you could do something like:
select minimum(source, destination) "pt1",
maximum(source, destination) "pt2"
from line
group by col1, col2
into new_line
Then join new_line to your point table to get the endpoint coordinates, and
create the line objects.
If the point IDs are non-numeric you may have to add a numeric ID (e.g.
rowid) and redefine the lines in terms of the numeric IDs by joining the
tables, or else use something other than MI to perform the query.
I'm not sure why minimum() and maximum() don't work on strings, since the
comparison operators =, <, <=, >, and >= seem to.
Scott Dunavan
Dunedin, New Zealand
>I have a table with no objects(line) that I would like to digitize between
>two points from an existing point table
>
>eg.
>
>two records represent a line from point A to Point B(point table)
>
>record one goes east from Point A to Point B
>record two goes west from Point B to Point A.
>
>The records are identical accept for their orientation . I would like to
>combine a column in order to have fewer records.
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
