Hi Claas,
Indeed that worked!!!! Thank you so much. Any idea if it's already in
the documentation somewhere (in which case I clearly didn't read the
manual...)? Otherwise I'll include that on my to do list.
Again, thanks,
Janneke
On 08/02/2019 00:47, Claas Leiner wrote:
Hi Janneke
in a similar problem,
it helped to update the spatial index:
---------
CREATE TRIGGER update_geom AFTER UPDATE ON watersources BEGIN
UPDATE watersources SET geom = Transform(MakePoint(east, north, 4326),
32638) WHERE id=1678;
-- I have done this in my trigger
Select recoverSpatialIndex('watersources','geom');
SELECT UpdateLayerStatistics('watersources');
END
------------------------
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
