hey list
can u have a quick look at the code at the bottom and
tell me if itz okay? Here's what it's supposed to do:
I have 2 tables, GRID2500TT (2.5 sqkm grid) and CWS
(road work schemes(object data)). Now, I want to go
through each row (sequentially) in the GRID2500TT
table, and at each row I want to select any records
from the CWS table where the objects are partly within
the GRID2500TT object. Once it'z identified records,
it puts it into a temp table to be ammended later on.
Whats happening: At the moment, it's selecting data
from the CWS table that fall within each row object of
GRID2500TT...i should end up with temp tables that
contain duplicate information (if the object can be
found in 2 or more grids), eg. temp54 should contain
all CWS objects that are partly within grid 54, and
temp 71 should contain the same information as temp54
because the CWS objects can be found in both grid 54
and 71...problem is, temp54 table and temp71 table
have a MapId of 71, instead of temp54 have records
with a MapId of 54 and temp71 having a Mapid of 71...i
thought putting them into seperate temp tables would
ensure no data was overwritten...and at the end add
the temp tables together to form one super table
containing duplicate records...
For Var_a = 1 to Num_Of_GRID
Select * From CWS
Where obj Partly Within (Select obj From Grid2500TT
Where ROWID = Var_a) Into Temp + Var_a
Update Temp + var_a
Set MapID = Var_a
next
thanx
Ben
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
_______________________________________________________________________
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.
