[Qgis-user] QGIS and database

[pcreso at pcreso.com]

Hi,

See the QGIS "actions" facility.

We did something similar in that if the point feature contained a link to a photo image, the defined action ran a command to display that photo on screen. As long at you can either hard code or read from the data all the required parameters, you can probably make something work.

Given the underlying command line nature of Linux vs Windows, this functionality is likely to more powerful on a Linux system.

Cheers,
   
  Bent Wood  

--- On Sat, 11/12/11, Patrice Vetsel <patrice at kagou.fr> wrote:

From: Patrice Vetsel <patrice at kagou.fr>
Subject: [Qgis-user] QGIS and database
To: qgis-user at lists.osgeo.org
Date: Saturday, November 12, 2011, 8:32 AM

Hi,
I'm searching if QGIS can do more interactions with databases.

Actually, I have a layer from a spatialite db. This layer contain points for outdoor lights for a town.
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.

I want to go further.
When I click on a point, I want QGIS launch a SQL query on a specific database, using informations from the same point (name), and shows me the result (list 5 last interventions on that light)
Do you have ideas for this?

Patrice VetselAka Kagou
-----Inline Attachment Follows-----

_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20111111/d29780c8/attachment.html>