Tim, I experience the same type of problem using MapInfo V5. A work-around in this instance is to use a single query. ie.
select * from Cities where obj within (select obj from States where stabbr = "WY" ) into WyomingCities This query should save as part of the workspace. Regards Tom Colley Environmental GIS Development Analyst Blue Mountains City Council Tel: (02) 4780 5433 Email: [EMAIL PROTECTED] Original Message ------------------------------ Date: Tue, 12 Nov 2002 09:56:03 -0600 To: [EMAIL PROTECTED] From: "Tim.Nuteson" <[EMAIL PROTECTED]> Subject: SQL statement not saved in workspace Message-ID: <[EMAIL PROTECTED]> 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: 4054
