<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
<font class="Apple-style-span" size="2" style="font-family: Tahoma; ">Hi, Giuseppe</font><br><span class="Apple-style-span" style="font-size: small; font-family: Tahoma; "><br></span><div><span class="Apple-style-span" style="font-size: 10pt; font-family: Tahoma; ">>>I'm trying to change the datasource of a postgis layer created with RT SQL, I mean, I want to make changes in the query after >>the layer is created. </span><br><div class="ecxgmail_quote"><div style="font-size: 10pt; font-family: Tahoma; "><br></div><div style="font-size: 10pt; font-family: Tahoma; ">>BTW, why would you change that value after the layer is created?<br>>If you have a valid reason or you think this should be the right behavior, <br>>file a ticket on trac.<br><br></div><div style="font-size: 10pt; font-family: Tahoma; ">For me, I'am using this way to display a label with three lines, containing the point name and its x,y coordinates, here is the query:</div><div style="font-size: 10pt; font-family: Tahoma; "><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><font class="Apple-style-span" size="2" face="Garamond"><span id="internal-source-marker_0.7191421180032194" style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">SELECT </span><br><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">"t_0"."ogc_fid",</span><br><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">"t_0"."wkb_geometry", </span><br><span style="color: rgb(0, 0, 0); font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; background-color: transparent; "></span><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">'Ponto '||"t_0"."ponto" ||'\n'||</span><br><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">'x='||CAST(ROUND(CAST(ST_X("t_0"."wkb_geometry") as numeric),0) as varchar) ||'\n'|| </span><br><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">'y='||CAST(ROUND(CAST(ST_Y("t_0"."wkb_geometry") as numeric),0) as varchar) </span><br><span class="Apple-style-span" style="white-space: pre-wrap;"></span><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">FROM "elektro"."pontos_arvores" AS "t_0"</span></font></div></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><font class="Apple-style-span" size="2" face="Garamond"><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; "><br></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><font class="Apple-style-span" size="2" face="Arial"><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">But I want to make changes, like, add another line with more info, or change the word 'Ponto' to uppercase.</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><font class="Apple-style-span" size="2" face="Arial"><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">To do that, I create another layer and delete the old one.</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><font class="Apple-style-span" size="2" face="Arial"><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; "><br></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><font class="Apple-style-span" size="2" face="Arial"><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">For now, it's the only way?</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><font class="Apple-style-span" size="2" face="Arial"><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; "><br></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><font class="Apple-style-span" size="2" face="Arial"><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">Regards.</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><font class="Apple-style-span" size="2" face="Arial"><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; "><br></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: transparent; "><font class="Apple-style-span" size="2" face="Arial"><span style="color: rgb(0, 0, 0); background-color: transparent; font-weight: normal; font-style: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap; ">Pablo.</span></font></div></div></div> </body>
</html>