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