I believe the problem is with base tables verses a named query. Try this
SQL which operates on the 2 base tables, USA which contains the state
objects and UsCuty_8k for the cities, or use any other city table you want.
Select * from Usa, Uscty_8k where Usa.State = WY AND Usa.obj Contains
Uscty_8k.obj into WyomingCities
Browse * From WyomingCities
William Woody Woodruff
Zoning Administrator
Charter Township of Union, Isabella County, Michigan
(989) 772 4600 EXT 41
Visit our web site at http://www.geocities.com/ctuzoning/index.htm
-Original Message-
From: Tim.Nuteson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 12, 2002 10:56 AM
To: [EMAIL PROTECTED]
Subject: MI-L SQL statement not saved in workspace
If I do these two selections in Mapinfo Pro:
select * from States where stabbr = WY into WyomingState
select * from Cities where obj within (select obj from WyomingState) into
WyomingCities
It works just fine. I end up with a table of WyomingCities I can map,
browse, etc.
When I save the workspace, however, only the first of the two select
statements is saved. When I load the workspace, it comes up with no sign of
the WyomingCities table. Is this normal, works-as-designed behavior?
Can anyone explain this? I'm using Mapinfo Pro 6.5
Thanks-
Tim Nuteson
Target Corporation
-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 4043
-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 4141