<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head>
<title></title>
<meta http-equiv="content-type" content="text/html;charset=utf-8"/>
<meta http-equiv="Content-Style-Type" content="text/css"/>
</head>
<body>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
Hi.</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
Is it possible to do something like this ?</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
I'd like to JOIN feature_id in dbf layer with information stored in SQL Server table by an SQl
Statement.</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
What about ? </span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
LAYER</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
NAME "pug_iffi"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
TYPE POINT</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
STATUS ON</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
TEMPLATE "query.html"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
DATA "puglia/pug_iffi.shp"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
TOLERANCEUNITS PIXELS</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
TOLERANCE 1000</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
CLASS</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
NAME "Pug_iffi"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
# TEMPLATE</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
STYLE</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
SYMBOL "circlefd"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
SIZE 7</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
COLOR 127 255 0 </span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
OUTLINECOLOR 0 0 0</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
END</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
END</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
JOIN</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
CONNECTION </span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
"<OGRVRTDataSource></span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<SrcDataSource>ODBC:sb/@dbo</SrcDataSource></span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<SrcLayer>Query_IdFrana</SrcLayer></span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</OGRVRTDataSource>"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
CONNECTIONTYPE OGR</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
TABLE "Query_IdFrana"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
TO "SELECT * FROM dbo.Query_IdFrana WHERE (cod_pro + id + subid = IDFRANA)"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
NAME "join"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
FROM "IDFRANA"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
END</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
PROJECTION</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
#Lat/Lon</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
"init=EPSG:32633"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
END</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
END</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
********************************************************************************************</span></font>
</div>
<div align="left"><img src="cid:33566435.1159210450.7292" width="89" height="36" border="0" alt="graphic"/>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
<b><br />
</b>
</span>
</font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
<b> Ing. Fabio D'Ovidio</b></span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
WebGIS Staff</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
Planetek Italia Srl</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
via Massaua, 12 - 70123 Bari - Italy</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
web : </span></font>
<font face="Comic Sans MS" color="#0000ff" size="2">
<span style=" font-size:10pt">
http ://www.planetek.it</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
e-mail : </span></font>
<font face="Comic Sans MS" color="#0000ff" size="2">
<span style=" font-size:10pt">
dovidio@planetek.it</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" color="#0000ff" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
********************************************************************************************</span></font>
</div>
</body>
</html>