Hi, It seems that Built-in functions in Spatialite is not working in Spatialite Manager and Custom Query plugin.
This query (below) is working in spatialite. However not in Spatialite Manager and Custom query plugin. See the results in spatialite terminal result. Select PK_UID, Area(Geometry) as Area, Glength(Geometry) as Perimeter from Regions where Name = 'VENETO'; spatialite> Select PK_UID, Area(Geometry) as Area, Glength(Geometry) as Perimeter from Regions where Name = 'VENETO'; 1|646397.805154562|3767.27751498312 2|1290337.68600099|6293.47638232552 3|8784619.91935909|26500.3924111861 4|530524.678980947|3393.68314026964 12|438895.715023518|3113.64992438381 13|1080844.97356853|4257.52369736528 27|631684.999314845|3312.26243379054 28|697028.860538453|3883.34841424143 29|1643348.74578464|7902.1272961186 30|2059950.71955425|9280.26957054055 31|3475156.56185258|8530.46975877753 32|2837714.23986262|11833.608036565 33|760252.960525573|3456.43315003721 34|3548959.66717082|10910.225574648 35|633458.679342464|3350.58352770575 36|732165.134682328|4345.32619131389 37|663225.180475533|3885.78466328978 38|918705.089251876|4344.70107002211 39|552058.274254918|4035.57280567915 40|1054773.22809702|5408.63784325175 41|1330499.79153974|6117.34545132715 42|1400447.12052478|6740.60779784617 43|464557.224632263|3508.45482974964 44|723247.97768569|3599.45282522162 45|651748.85301292|3801.78008569203 46|548118.492645741|3712.45734461941 47|488050.567765743|3177.6569314083 48|752451.875753649|3537.1586256791 49|6069461.72734681|23020.9974671427 50|9739.59230065346|719.590296605301 108|18045728269.4635|1202815.64345084 spatialite> Thanks. Noli _______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
