[Qgis-developer] Re: Built-in functions in Spatialite is not working in Spatialite Manager and Custom Query plugin.

[Noli Sicad]

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
<ricardo.garcia.silva at gmail.com> 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 <nsicad at gmail.com> 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
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>