Hi Ricardo, I am using Ubuntu 10.04 but I updated my Qgis lately to the trunk version r14914m in the nightly built since I was not getting the Database Menu.
In this repo deb http://qgis.org/debian-nightly lucid main deb-src http://qgis.org/debian-nightly lucid main What is the version of your ubuntu QGIS and what is the repository? Thanks. Noli On 12/17/10, Ricardo Filipe Soares Garcia da <[email protected]> wrote: > Hi Noli > > I can run your query in both plugins without any problem. > Maybe the real problem lies elsewhere. > > I have been using using ubuntu almost exclusively lately, with > packages from the ubuntugis repository. So I really haven't had a > chance to test these things out on diferent OS/software versions. I > was expecting everything to work OK though. > > What are your system specs? > Do you have the pyspatialite python module installed? > > Can anyone else reproduce Noli's error? > > > On Fri, Dec 17, 2010 at 11:08 AM, Noli Sicad <[email protected]> wrote: >> 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 >> > > > > -- > ___________________________ ___ __ > Ricardo Garcia Silva > _______________________________________________ > Qgis-developer mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-developer > _______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
