<div>Hi Moritz,</div>
<div> </div>
<div>As I am using dbf, with v.db.addcol + v.db.update it is running find.</div>
<div> </div>
<div>Thanks!</div>
<div> </div>
<div>milton<br><br></div>
<div class="gmail_quote">2009/7/2 Moritz Lennert <span dir="ltr"><<a href="mailto:mlennert@club.worldonline.be">mlennert@club.worldonline.be</a>></span><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class="im">On 02/07/09 18:52, Milton Cezar Ribeiro wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Dear all,<br> I just imported a shapefile on GRASS, and I need to convert several fields from CHAR to numeric (double precision) - at my own risk, of course.<br>
Can I do it on grass, or I need to redo the thinks on arcgis ?!<br></blockquote><br></div>Depends on your database backend. In PostgreSQL (and perhaps SQLite), you could do something like this:<br><br>echo "alter table XYZ alter column ABC type numeric" | db.execute<br>
<br>I don't think anything like this would be possible in dbf...<br><br>You could also try a combination of v.db.addcol + v.db.update to create new numeric columns and set the value of these columns to the value of the varchar column.<br>
<font color="#888888"><br>Moritz<br></font></blockquote></div><br>