[GRASS-user] Connect additional dbf file based on layer 1 attribute column

[Luigi Ponti]

Hamish wrote:
> Luigi:
>   
>> Does the GRASS DBF engine has a size limitation for some operations?
>> I got an error while trying the following:
>>
>>     GRASS 6.2.2 (SoilEurope2):~ >d.vect -c sgdbe4_0_reclass
>> display=attr
>>     attrcol=EAWC_TOP
>>     DBMI-DBF driver error:
>>     SQL parser error in statement:
>>     select EAWC_TOP from smu_ptrdb.dbf where cat = 330677
>>     Error in db_open_select_cursor()
>>
>>     ERROR: Cannot select attributes:
>>            select EAWC_TOP from smu_ptrdb.dbf where cat = 330677
>>
>> Note that cat=330677 is 2572th row of the .dbf table (if I change 
>> attribute column, I always get an error on the same cat).
>>     
>
>
> select EAWC_TOP from smu_ptrdb where cat = 330677
>  not
> select EAWC_TOP from smu_ptrdb.dbf where cat = 330677
>   
Yes, my fault: I had tried to v.db.connect using a table name with .dbf 
extension (i.e., smu_ptrdb.dbf). When using smu_ptrdb instead, all went 
well. Apparently the DBF driver assumes the table has a .dbf extension.
Thanks and regards,

Luigi


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20080401/71d83618/attachment.html