Neil,
I guess it depends whether you actually do want to delete the "outside"
data (i.e. never be able to access it again) or just to select the
required data.
I'm no expert on MapBasic but what I'd do is:
To just select the required data:
Go through all your tables, either one by one, naming them or in a loop,
and
Select * from <currentTable> into <currentcursor> where
<currenttable>.obj within PolygonTable.obj.
Then use just your resultant cursors to make up the display map.
To delete what's not wanted, in the same sort of loop, for each table:
Do while not EOT(<currentTable>)
If obj not within PolygonTable.obj then
lnRowID = RowId
Delete from <currenttable> where RowID = lnRowID
End if
loop
HTH
Terry
-----Original Message-----
From: neil kashishian [mailto:[EMAIL PROTECTED]
Sent: 18 June 2004 14:09
To: [EMAIL PROTECTED]
Subject: MI-L selecting all within buffer from multiple tables
Hi guys,
Ive a quick question for you, nothing too technical but its doing my
head in!
I've got a map open of North West London (camden) and have a polygon
over the roads,parks,etc(about 10 different tables).
now, how do I select everything that falls within this boundary and
delete everything else? there are about 30 tables open ith roads, parks,
lakes, etc.
any help highly appreciated!
thanks as always,
cheers
-Neil.
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 12312
