I used Mapbasic and made data imported from excel into mappable and added projection to WGS 84 and updated table using:

update TABLE set obj = createline(x1,y1,x2,y2)

to create line and the line was create which I could see in mapper window but when I looked at the browser window the no of column has not changed. How is this obj created stored in table in .tab file as I can see spatial coordinate in MS SQL table.

  • Is this a native table or a MS SQL linked table? – Nathan W Aug 11 '11 at 5:53
  • @Nathan W This is native table – kinkajou Aug 11 '11 at 6:26
  • If you open up your tab file, you'll see there's simply a link for the database. When you upload the data, or create the data, you have an option, iirc, of live access, or linked. If it is live, it downloads all the data, if linked, all the data stays server side. As I said, iirc. – Hairy Aug 11 '11 at 7:01
  • @Hairy I could not understand :( – kinkajou Aug 11 '11 at 7:13
  • 2
    Open the tab file in notepad++ (there are other editors) and have a look at the code in there; it will tell you how you open the database and have the data. A live link means you don't have data on the client, but work on it at the DB level, if it you create a copy of it, you create a local copy of the data. Again, iirc. If you are using live link, you may need to refresh the view, to force the changes into MapInfo; it is an area to look into, and something I thought could be an issue, but it's not an answer, hence the comment. – Hairy Aug 11 '11 at 7:32

MapInfo will not let you see the spatial data in the browser, it is only visible in the map. MapInfo stores the spatial data (your lines) in the map file and the alphanumerical data in the .DAT (.TXT, .XLS or whatever format you are using).

If you need to see some parts of the spatial data inside MI Pro, you need to query these parts using SQL Select.

  • 1
    If there's a direct link, there is no DAT file Peter. – Hairy Aug 11 '11 at 8:49
  • If there is no .DAT, then you have your data in another format, which cann be .XLS, .TXT, .DBF or a number of other formats. The .ID file "links" the alphanumerical data (in the .DAT, .XLS or whatever) with the spatial data in the .MAP file. – Peter Horsbøll Møller Aug 15 '11 at 8:26
  • Peter, no, sorry, but you've not understood the problem/question. If the data is live linked to the spatial data in the database, there is no DAT/XLS/DBF/TXT or anything, it is live linked to the data in the DB. The only time a DAT file (or others) is created, is if you store, or wish to access, the data locally. – Hairy Aug 15 '11 at 9:06
  • Sorry, I missed that one. If it is live without cache, the data (alphanumericla as well as spatial is stored in memory). If it is live with cache, it is stored in a set of files kept in the temp folder. – Peter Horsbøll Møller Aug 15 '11 at 20:08
  • No worries, that was what I was trying to convey. – Hairy Aug 16 '11 at 6:04

Update table set obj=createline(Long_B,Lat_B,Long_A,Lat_a)

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

  • Please provide additional information. As it stands, it does not answer the question of how the object is created & stored. – MaryBeth Dec 30 '16 at 13:30
  • Welcome to GIS SE! As a new user please take the tour to learn about our focused Question and Answer format. A good answer should include explanation on how to solve the problem, not just a single line of code. Please edit your answer to include additional info on how and why your answer is the answer. – Midavalo Dec 30 '16 at 15:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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