I should read this more carefully, but I don't have time... Live access does not always go back to the database. While you updated the Oracle table the new values have not "reached" MapInfo yet. The query must be re-executed for this to occur. When you say "refresh" you need to "refresh table", but I'm not sure if this has the desired affect with live access. I don't have time to test, but I didn't think that refresh table would bring up a live access tables, only linked tables?
A sloppy alternative is to move the extent of the mapwindow. If you zoom in within the same mapwindow extent, for example, there is no need to go back to Oracle. A display refresh does not require that the query be re-executed. You must Move so that the extent changes and forces the query to be executed again to get the new features. The display update occurs when you edit from MapInfo because you are actually working on the local data (Yes even live access creates local data, just not in a TAB file.) then the update is posted back to Oracle. -----Original Message----- From: Damian Skeeles [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 02:35 PM To: [EMAIL PROTECTED] Subject: MI-L Live update of Thematically Mapped Table > Hi there, > > I'm having some problems getting changes in a live, uncached Oracle > Spatial table to replicate on a Thematic map, in Mapinfo Pro 7.0. I > effectively have a chain of three tables: > > 1. The original TRAFFIC_STATS table in an Oracle database: this contains > two fields, SITE_ID, and TRAFFIC_COUNT > 2. The same TRAFFIC_STATS table, as opened in Mapinfo Pro as a Live Access > table > 3. A separate, mappable table, DISPLAY, which only has one field of it's > own : SITE_ID > > TRAFFIC_STATS and DISPLAY have the SITE_ID field in common. When creating > the thematic map, I created a join on SITE_ID, and set DISPLAY to show the > field TRAFFIC_COUNT. > > So - we're taking a non-mappable Oracle table, joining it with a mappable > Mapinfo table, and displaying the Oracle table's values thematically > through this Mapinfo table. > > The problem is that when I make a change to one of the TRAFFIC_COUNT > values in the Oracle database, it doesn't propagate through all the way to > the display. Looking at the table browsers, the Mapinfo instance of > TRAFFIC_STATS (2., above) does instantly show the change - so I know this > link is working. However, the DISPLAY table (3.) doesn't reflect this > change, even if I try a refresh, or close and open the browser. > > On the other hand - if I make a manual change in TRAFFIC_STATS in the > Mapinfo table (2.), then DISPLAY instantly reflects the change, and the > thematic colours update. > > > So - it looks like Mapinfo refreshes Joined tables only when it detects an > edit to the source table within Mapinfo, but not if that table changes via > the Live Oracle link. > > Can anyone offer any advice on how I can get these changes to propagate > all the way through to the end? > > Many thanks, > > > Damian > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11332
