
<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Hi,</div><div><br></div><div>I'm searching if QGIS can do more interactions with databases.</div><div><br></div><div><br></div><div>Actually, I have a layer from a spatialite db. This layer contain points for outdoor lights for a town.</div><div><br></div><div>If I click a point, I obtain informations and can edit them (name, type, number, power …). All of these are from the table already opened from the spatialite db.</div><div><br></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: arial, sans-serif; "><span class="hps"><br></span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: arial, sans-serif; "><span class="hps">I want to</span> <span class="hps">go further.</span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: arial, sans-serif; "><br><span class="hps">When I click on</span> <span class="hps">a</span> <span class="hps">point</span><span>, I want</span> <span class="hps">QGIS</span> <span class="hps">launch a</span> <span class="hps">SQL query</span> <span class="hps">on a</span> <span class="hps">specific</span> <span class="hps">database</span><span>, using</span> <span class="hps">informations from</span> <span class="hps">the same point</span> <span class="hps">(name),</span> <span class="hps">and shows me</span> <span class="hps">the result (list 5 last interventions on that light)</span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: arial, sans-serif; "><span class="hps"><br></span></span></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: arial, sans-serif; "><span class="hps">Do you have</span> <span class="hps">ideas for</span> <span class="hps">this?</span></span></div><br>

Patrice Vetsel<div>Aka Kagou</div></body></html>