Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
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
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
up vote 1 down vote accepted

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.

share|improve this answer
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

Your Answer


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.