<HTML>
<HEAD>
<TITLE>Re: [GRASSLIST:8184] Syntax for v.db.addcol?</TITLE>
</HEAD>
<BODY>
<FONT FACE="Verdana, Helvetica, Arial"><SPAN DEFANGED_STYLE='font-size:12.0px'>It is Colour varchar(#n)<BR>
<BR>
where #n is an integer defining the length of the string variable<BR>
<BR>
e.g., Colour varchar(10) creates a string character named Colour that is 10 characters long.<BR>
<BR>
Michael<BR>
______________________________<BR>
Michael Barton, Professor of Anthropology<BR>
School of Human Evolution and Social Change<BR>
Arizona State University<BR>
Tempe, AZ 85287-2402<BR>
USA<BR>
<BR>
voice: 480-965-6262; fax: 480-965-7671<BR>
www: <a href="http://www.public.asu.edu/~cmbarton">http://www.public.asu.edu/~cmbarton</a><BR>
<BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"><B>From: </B>"Patton, Eric" <epatton@nrcan.gc.ca><BR>
<B>Date: </B>Tue, 6 Sep 2005 15:30:40 -0300<BR>
<B>To: </B>"'GRASSList (GRASSLIST@baylor.edu)'" <GRASSLIST@baylor.edu><BR>
<B>Subject: </B>[GRASSLIST:8184] Syntax for v.db.addcol?<BR>
<BR>
</SPAN></FONT><SPAN DEFANGED_STYLE='font-size:12.0px'><FONT COLOR="#000080"><FONT FACE="Arial">I was wondering what syntax the program expects for this to work. I'm using the GUI version of v.db.addcol in WinGrass 6.1 cvs-5, the Sept. 5th binary from Cho's site. <BR>
The program asks for the name and type for the new column to be added to the database, but I can't seem to stumble on the correct syntax for it.<BR>
</FONT></FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
</FONT><FONT COLOR="#000080"><FONT FACE="Arial">I've tried: <BR>
a) Colour,VARCHAR<BR>
b) Colour"VARCHAR"<BR>
c)"Colour"VARCHAR<BR>
d)"Colour",VARCHAR<BR>
</FONT></FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
</FONT><FONT COLOR="#000080"><FONT FACE="Arial">Any ideas?<BR>
</FONT></FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
<BR>
<BR>
</FONT><FONT COLOR="#000080"><FONT FACE="Arial">~ Eric.<BR>
</FONT></FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
<BR>
</FONT><FONT FACE="Arial">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<BR>
</FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
</FONT><FONT COLOR="#000080"><FONT FACE="Arial"><B>Eric Patton<BR>
</B></FONT></FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
</FONT><FONT COLOR="#000080"><FONT FACE="Arial"><I>Technologist, Geo-Spatial Data Services<BR>
Geological Survey of Canada (Atlantic)<BR>
Natural Resources Canada<BR>
Bedford Institute of Oceanography<BR>
Dartmouth, Nova Scotia, Canada B2Y 4A2<BR>
</I></FONT></FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
</FONT><FONT COLOR="#000080"><FONT FACE="Arial"><I>Postal address: P.O. Box 1006<BR>
Courier address: 1 Challenger Drive<BR>
</I></FONT></FONT><FONT FACE="Verdana, Helvetica, Arial"> <BR>
</FONT><FONT COLOR="#000080"><FONT FACE="Arial"><I>Telephone: (902)426-7732<BR>
Facsimile: (902)426-4104<BR>
E-mail: </I></FONT></FONT><FONT FACE="Arial"><I>epatton@NRCan.gc.ca</I></FONT><FONT FACE="Verdana, Helvetica, Arial"> <a href="mailto:epatton@NRCan.gc.ca"><mailto:epatton@NRCan.gc.ca></a> <BR>
<BR>
<BR>
<BR>
</FONT></SPAN>
</BODY>
</HTML>