[GRASSLIST:2668] Re: error in v.distance

[Radim Blazek]

On Tuesday 17 February 2004 15:18, Leonardo Lami wrote:
> I'm testing v.distance on 5.7 and I choosed the upload table option but at
> the end of the run it says:
> ....
> ....
> load_table_head(): tab=1,
> /home/Documenti/datigrass/Pisa/prova/dbf//danni.dbf 169 cats selected from
> the table
> SQL: update danni set aac=5435.45 where cat=1
> find_table(): table=danni
> ? aac
> ? danni
> /home/Documenti/datigrass/Pisa/prova/dbf//danni.dbf
> dbmi: protocol error
> SQL: update danni set aac=5664.35 where cat=2
>
> The error may be in the double "/" in the string:
> load_table_head(): tab=1,
> /home/Documenti/datigrass/Pisa/prova/dbf//danni.dbf

No, '//' is not problem.

> please can any one help me to solve the problem.

Do you have column 'aac' (floating point) in your table, try db.describe/db.columns.
Try to do the same using db.execute. 
echo "update danni set aac=5664.35 where cat=2" \
| db.execute driver=dbf database=/home/Documenti/datigrass/Pisa/prova/dbf/



Radim