Hello all!
I am trying to build an MBX to quickly combine a table of street data into
one object per unique name. I am fairly new to MapBasic and so cant figure
out exactly where I may be going wrong with the following:
dim myroad as string
Select * from WA_MNRD group by STREET into UNQROADS
fetch first from UNQROADS
do while NOT EOT(UNQROADS)
myroad=selection.street
select * from WA_MNRD where STREET = myroad
objects combine data Street=myroad
fetch next from UNQROADS
loop
When I run the MBX it appears to be combining some records but not in the
way I wished. Does anyone have any pointers? Am I missing something
blindingly obvious?
Thanks in advance!
Julian Parker
Digital Mapping Solutions
2/2 Hardy St SOUTH PERTH WA 6151
Ph 9474 6311 Fax 9474 6411
www.mapsolutions.com.au
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 5845
