[Qgis-user] Geopagkage and "geom" in DBmanager

[Alexandre Neto]

Hi Lee,

Can you try removing the quotation marks around geom?

Best wishes,

Alex Neto

A qui, 13/09/2018, 02:04, Lene Fischer <lfi at ign.ku.dk> escreveu:

> Hi,
> Trying out a geopackage layer in DBManager asking a simple SQL statement
> st_area
> But when I try to write a statement like this
>
> SELECT "vandopland".* , st_area("vandopland"."geom") as areal_m2
> FROM "vandopland"
>
>  "geom" is not found. Suggestions as geomfromexifgpsblob or geomfromfgf or
> geomfromwkb . Then I get "an error occured"
>
> Any suggestions what I might have done wrong.
>
> Regards from a newbee Geopagkace/DBmanager
>
> Lene Fischer
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Alexandre Neto
---------------------
@AlexNetoGeo
http://sigsemgrilhetas.wordpress.com
http://gisunchained.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180913/1f3aec86/attachment.html>