[GRASS-user] query of attribute data

Nikos Alexandris nikos.alexandris at felis.uni-freiburg.de
Mon Feb 25 09:09:28 EST 2008


On Mon, 2008-02-25 at 13:51 +0000, christian Brandt wrote:
> Dear List,
> 
> using the statement 
> 
> v.db.select geb_grd_RG2_test3 where="A_area <= 4.195,27"
> 
> to query an attribute table gives me the error message 
> 
> DBMI-DBF driver error:
> SQL parser error in statement:
> SELECT * FROM geb_grd_RG2_test3 WHERE A_area <= 4.195,27
> Error in db_open_select_cursor()
> 
> Can anybody help?

Christian,

just a silly question: Can you confirm the connection with the database?

>db.connect -p driver=dbf

or directly with your table:

>db.describe -c geb_grd_RG2_test

or

>db.select geb_grd_RG2_tes
        
        
> 
> Greetings
> 
> Chris
> 
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/_______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
-- 
Nikos Alexandris
.
Department of Remote Sensing & Landscape Information Systems
Faculty of Forestry & Environmental Sciences, Albert-Ludwigs-University Freiburg
.
Tel.  +49 (0) 761 203 3697 / Fax.  +49 (0) 761 203 3701 / Skype: Nikos.Alexandris
.
Address: Tennenbacher str. 4, D-79106 Freiburg i. Br., Germany
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.osgeo.org/pipermail/grass-user/attachments/20080225/7245753a/attachment.bin


More information about the grass-user mailing list