[Qgis-user] spatialite with update trigger seems to result in 'unselectable' geometry
Janneke van Dijk
janneke.qgis at gmail.com
Sat Feb 9 02:05:02 PST 2019
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
> ------------------------
>
>
>
More information about the Qgis-user
mailing list