Re: [MI-L] DBMS table refresh issue

[Peter Horsbøll Møller]

Not as it works right now.

If you were using a live table the table structure would be updated everytime MI Pro reopens the table (unless you have specified the exact columns to get from the database)

And that is, at least partial, also the reason why a linked table doesn't reflect changes in the database - the query specifically mentions which columns to extract data from.

You would probably need to write your own way of opening these tables if you want the data structure to be reflected in the tab files.

Adding the columns manually to the query string in the tab file might not be the best solution as the table structure of the dat file doesn't match that changed structure.

 
Peter Horsbøll Møller
Pitney Bowes Software

2012/6/15 Chan Ryan <yma...@gmail.com>

I wonder if the "DBMS refresh table" can detect the table structure change in the SQL server.

I created a tab file (linked table, not live access)  for a table in the SQL server 2008. Then I added a couple of columns

into that table in the SQL server. I refreshed the DBMS table in MapInfo, however, I couldn't see the newly added columns.

I need to manually add the new column names in the tab file (in the "\DATALINK\Query") or re create the linked table tab file in order to see the changes.

Is there any ways for MapInfo to do automatically?

--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en