Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have laoded my lines data in MS-SQL in one table. I have points data in DBMS as well in separate table . When I open both table the map window would show lines and points as I want but now when I join more points the data is updated to points table. And since point table is table to store points only and line table is to store line data only. How is it possible to solve this issue so that when I connect points Line table is updated?

I am using

  1. Microsoft SQL 2008
  2. Connect the dots Tool to connects points ( actually I need line data in line table)
  3. Mapinfo 10.0
share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

You'll have to run the connect the dots tool again. The editable layer, I presume, is the dots layer, so when you are creating the points, it automatically appends the data.

It seems to me, that you should load ALL of your point data, and then run the points to lines tool.

Have you not thought about adding the lines manually direct to the line table?

share|improve this answer
    
Can I store points and line in same table ? –  kinkajou Aug 15 '11 at 15:23
1  
This is not a true answer, just a suggestion. You could create a view in SQL Server that creates a line using the two points in your points table. In this way the lines will be created when you open the view. All you need to do is create new points. If you have more than two points in each line it will get a bit more tricky, but using a Userdefined Function could do the trick –  Peter Horsbøll Møller Aug 15 '11 at 20:01
    
PS: SQL Server does support multiple spatial coulmns in a single table, but I'm not sure how MapInfo Pro would. Of course the MapInfo-MapCatalog would specify which column to use for the spatial data, but ... –  Peter Horsbøll Møller Aug 15 '11 at 20:02
    
+1 Thanks for Answer @Hairy –  kinkajou Aug 16 '11 at 4:04
    
+1 @Peter It was helpful –  kinkajou Aug 16 '11 at 4:04
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.