Hello,
I'm
trying to have a specific little MapBasic tool that will join my map
layer
to a
SQL server table of some additional data through ODBC.
I
would then like to do a spatial query on an additional map layer, and
extract
the
extra data, if the spatial query is true.
I can
seem to open the map layers and make the ODBC table linked in, but
I
am not
sure how to join the additional data to the map layer, to enable us to
attempt
the
spatial query.
So far
all I've got is :
Sub
Main
Dim ODBC_handle As String
include "mapbasic.def"
Dim ODBC_handle As String
include "mapbasic.def"
Open Table "C:\Temp_Maps\LP_polygons.TAB" As
LP_map
Server Link Table "Select * From local_plans_policys"
Using
"DSN=LLC_planning_policy_lookup;UID=user;PWD=password"
Into LP_policys File "C:\Temp\LP_policys"
"DSN=LLC_planning_policy_lookup;UID=user;PWD=password"
Into LP_policys File "C:\Temp\LP_policys"
Map from LP_map
End Sub
End Sub
I
tried to add the join to the Link Table SQL, but MapInfo complained that LP_map
wasn't
a
table.
Do
anyone have some code or help that can illustrate how to append extra data from
SQL
server
via ODBC to open map layer, which enable me then to run a spatial query on the
map
layer
and extract the added data columns.
Thanks
Nathan
---------------(\./)---------------
Nathan Carr
GIS Developer
LLPG/LSG Custodian & ALO
Swale Borough Council
Email : [EMAIL PROTECTED]
Phone : 01795 417 337
Mobile : 07957 461 685
Nathan Carr
GIS Developer
LLPG/LSG Custodian & ALO
Swale Borough Council
Email : [EMAIL PROTECTED]
Phone : 01795 417 337
Mobile : 07957 461 685
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager at [EMAIL PROTECTED]
This message has been scanned for viruses by BlackSpider MailControl
I.T. Services
Swale Borough Council
Visit http://www.swale.gov.uk
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
