> 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
>
