On 12/11/2012 13:00, Bernd Vogelgesang
wrote:
Here's some "witchcraft"
In a spatialite DB, I have a polygon table "fields". I Added an
integer column "val"
and a column "result_val" of type real. Then I set up this
Here's some "witchcraft"
In a spatialite DB, I have a polygon table "fields". I Added an integer
column "val"
and a column "result_val" of type real. Then I set up this trigger:
CREATE TRIGGER update_result_trig
AFTER UPDATE ON "fields"
BEGIN
UPDATE fields
SET result_val=(val*ST_Area(geometry
On 12/11/2012 00:14, Bernd Vogelgesang
wrote:
Hi,
i'm searching for a solution for updating field values easily
while
editing the layer.
I have a layer consisting of polygons which represent areas with a
certain
Il 12/11/2012 07:14, Bernd Vogelgesang ha scritto:
>
> I also know, that in spatialite, there is a possibility to have triggers
> to do such things, but those introductions are even more unexisting and
> mysterious.
Frankly, any other solution is either more complicate, less stable, or both.
Avving
Hi,
i'm searching for a solution for updating field values easily while
editing the layer.
I have a layer consisting of polygons which represent areas with a certain
base value.
Those values multiplied with the polygons area give a result value for the
area which is interesting for us.
We have t