Re: [Qgis-user] Spatialite queries return text instead of numeric values

2014-12-10 Thread Goyo
2014-12-10 1:50 GMT+01:00 Alexandre Neto senhor.n...@gmail.com: Hello, When querying a spatialite database in the database manager, if you create some calculations (say add two columns values) the resulting column returns as TEXT instead of the expected numeric field. Is this intended or a

Re: [Qgis-user] Spatialite queries return text instead of numeric values

2014-12-10 Thread Alex Mandel
On 12/10/2014 09:55 AM, Goyo wrote: 2014-12-10 1:50 GMT+01:00 Alexandre Neto senhor.n...@gmail.com: Hello, When querying a spatialite database in the database manager, if you create some calculations (say add two columns values) the resulting column returns as TEXT instead of the expected

Re: [Qgis-user] Spatialite queries return text instead of numeric values

2014-12-10 Thread Alexandre Neto
Hello all, To make some tests I have the folllowing table: General info Relation type: Table Rows: 3 SpatiaLite Column: geometry Geometry: MULTIPOLYGON Dimension: XY Spatial ref: WGS 84 (4326) Extent: (unknown) (find out action:extent/get) Fields # Name Type Null

Re: [Qgis-user] Spatialite queries return text instead of numeric values

2014-12-10 Thread Alex Mandel
What happens if you CREATE VIEW with those tests? Does QGIS read the VIEW differently? Thanks, Alex On 12/10/2014 10:57 AM, Alexandre Neto wrote: Hello all, To make some tests I have the folllowing table: General info Relation type: Table Rows: 3 SpatiaLite

[Qgis-user] Spatialite queries return text instead of numeric values

2014-12-09 Thread Alexandre Neto
Hello, When querying a spatialite database in the database manager, if you create some calculations (say add two columns values) the resulting column returns as TEXT instead of the expected numeric field. Is this intended or a bug? Trying to cast it as real, double or float did not work either.