You should be able to do this via SQL in the Query Menu. Open the SQL
dialog box. Place the cursor in the From Tables box and click the pull down
list for tables, select the ACD World Map table. Put the cursor in the
Where box and select the Columns pull down and select the column ETYPE.
Leave it there (the cursor) and go to the Operators pull down and select the
= sign, now type in the ETYPE category you want to select, placing it in
Quotes (e.g. "W"). You can place the cursor in the Order by, select another
column from that table to order by. You can place the query into a table
name you create by writing over Selection in the Into Table Named box to set
it apart from the standard Query 1, 2 etc. Press the Verify button to make
sure its all according to Hoyle. If you now save the workspace with the new
named table browser open, every time you open the workspace the SQL will run
and update your table. If you don't want that, close the browser before
exiting and / or saving workspace.
JFG (just for grins) have the map basic window open in the background and
you can see how the SQL is scripted. Although I'm not sure of the exact name
of your table or your different types of region codes, It might look like
this:
Select * from ACD_World_Map where ETYPE = "W" into Water_Regions
Browse * From Water_Regions
William Woodruff
Zoning Administrator
Charter Township of Union, T14 N R4W, Isabella County, Michigan
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Eberl,Christine [NCR]
Sent: Monday, January 31, 2000 4:11 PM
To: '[EMAIL PROTECTED]'
Subject:
Hi Listers! I am hopelessly unfamiliar with mapbasic and have been trying
to use the Query/select function to pick out specific objects within an ACD
world map table of boundaries North American. Each type of boundary (ie
state/provincial, federal, ocean,etc) is assigned a different value in the
'ETYPE' column of the table, and I would like to select one of these
boundary types to save to a new table. I'm sure that the Q/S is the way to
go, I just can't figure out the syntax. I'm Stuck... Can someone help
me????
Many thanks for any help! Cheers Christine
(for those who are interested, I'm still working on the layout
metafile/eps/pdf file problem - having trouble opening eps file in a free
version of adobe illustrator from the net - will keep you posted if I get it
worked out....)
phone: (819) 997-6082
fax: (819) 953 - 6612
email: [EMAIL PROTECTED]
Address: Christine Eberl
Migratory Birds Technician
Canadian Wildlife Service
100 Gamelin Blvd
Hull, PQ
K1A 0H3
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
