I have experienced the same thing.
MapInfo say its because MI cant handle one to many relationships.
But its fine in the resulting query browser.
I think that its a bug in the info tool.
Dave Andrews
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Tim Warman
Sent: 01 May 2001 21:45
To: Mapinfo-L
Subject: SUM: MI-L mismatch between map & browser windows after query
Okay, the answer straight from MapInfo Tech Support is "It's supposed to
work that way".
How disappointing.
MI's suggestion was to save a copy of the query result, which does seem to
correct the problem. They claim that MI doesn't really support one-to-many
joins, and that this lack of support shows up when trying to use the info
tool in a map window with a temporary query table spawned from a one-to-many
join.
Cheers,
_____________________________
Tim Warman
Groundwater Geologist/GIS Guy
Richard C. Slade & Associates LLC
North Hollywood, CA, USA
+1 (818) 506 0418
-----Original Message-----
From: Roger Therrien [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 12:42 PM
To: Tim Warman
Subject: Re: MI-L mismatch between map & browser windows after query
I get exactly the same problem with my SQL query generate table using MI
v6.0.
I hope somebody knows the answer to this one.
Roger
Tim Warman wrote:
> Hey Listers,
>
> I have one table containing water well locations, and a second containing
> water level elevations in these wells, measured at various times over the
> past 50 years.
>
> I've run a query to join the two tables and find any water level data for
> the spring of 2000 - the output goes into a new table called Spring_2000.
In
> the browser window for Spring_2000 I find (for example) three records for
> Well 19, consisting of water levels for each of the three spring months.
> But, when I map Spring_2000 and click on a well with the info tool, I only
> see one record repeated three times.
>
> TIA
>
> _____________________________
> Tim Warman
> Groundwater Geologist/GIS Guy
> Richard C. Slade & Associates LLC
> North Hollywood, CA, USA
> +1 (818) 506 0418
>
> _______________________________________________________________________
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, send e-mail to [EMAIL PROTECTED] and
> put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
