Hi,

2007/10/18, Carlos Guâno Grohmann <[EMAIL PROTECTED]>:
> OK, I am trying to get these thing working with db.execute.
>
> although these work:
> > echo "UPDATE Lineam_isobase SET dx=end_x-start_x" | db.execute
> > echo "UPDATE Lineam_isobase SET dy=end_y-start_y" | db.execute
>
> this doesn't:
>
> > echo "UPDATE Lineam_isobase SET ang_rad=atan2(dx,dy)" | db.execute
> DBMI-DBF driver error:
> SQL parser error:
> in statement:
> UPDATE Lineam_isobase SET ang_rad=atan2(dx,dy)
>
> Error in db_execute_immediate()
>
> ERROR: Error while executing: 'UPDATE Lineam_isobase SET
>        ang_rad=atan2(dx,dy)
>        '

Use instead of DBF e.g. pg driver, atan2() is not supported by DBF driver.

Martin

-- 
Martin Landa <[EMAIL PROTECTED]> * http://gama.fsv.cvut.cz/~landa *

_______________________________________________
grassuser mailing list
grassuser@grass.itc.it
http://grass.itc.it/mailman/listinfo/grassuser

Reply via email to