[GRASSLIST:8184] Syntax for v.db.addcol?

GRASS GRASS user
1

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.
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.

I've tried:
a) Colour,VARCHAR
b) Colour"VARCHAR"
c)"Colour"VARCHAR
d)"Colour",VARCHAR

Any ideas?

~ Eric.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Eric Patton

Technologist, Geo-Spatial Data Services
Geological Survey of Canada (Atlantic)
Natural Resources Canada
Bedford Institute of Oceanography
Dartmouth, Nova Scotia, Canada B2Y 4A2

Postal address: P.O. Box 1006
Courier address: 1 Challenger Drive

Telephone: (902)426-7732
Facsimile: (902)426-4104
E-mail: <mailto:epatton@NRCan.gc.ca> epatton@NRCan.gc.ca

2

How about:

Colour VARCHAR

(no comma or else at all)

Maciek

From: "Patton, Eric" <epatton@nrcan.gc.ca>
To: <GRASSLIST@baylor.edu>
Sent: Tuesday, September 06, 2005 8:30 PM
Subject: [GRASSLIST:8184] Syntax for v.db.addcol?

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.
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.

I've tried:
a) Colour,VARCHAR
b) Colour"VARCHAR"
c)"Colour"VARCHAR
d)"Colour",VARCHAR

Any ideas?

~ Eric.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Eric Patton

Technologist, Geo-Spatial Data Services
Geological Survey of Canada (Atlantic)
Natural Resources Canada
Bedford Institute of Oceanography
Dartmouth, Nova Scotia, Canada B2Y 4A2

Postal address: P.O. Box 1006
Courier address: 1 Challenger Drive

Telephone: (902)426-7732
Facsimile: (902)426-4104
E-mail: <mailto:epatton@NRCan.gc.ca> epatton@NRCan.gc.ca

3

It is Colour varchar(#n)

where #n is an integer defining the length of the string variable

e.g., Colour varchar(10) creates a string character named Colour that is 10 characters long.

Michael

Michael Barton, Professor of Anthropology
School of Human Evolution and Social Change
Arizona State University
Tempe, AZ 85287-2402
USA

voice: 480-965-6262; fax: 480-965-7671
www: http://www.public.asu.edu/~cmbarton

From: “Patton, Eric” epatton@nrcan.gc.ca
Date: Tue, 6 Sep 2005 15:30:40 -0300
To: “‘GRASSList (GRASSLIST@baylor.edu)’” GRASSLIST@baylor.edu
Subject: [GRASSLIST:8184] Syntax for v.db.addcol?

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.
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.

I’ve tried:
a) Colour,VARCHAR
b) Colour"VARCHAR"
c)"Colour"VARCHAR
d)“Colour”,VARCHAR

Any ideas?

~ Eric.


**Eric Patton**

*Technologist, Geo-Spatial Data Services*
*Geological Survey of Canada (Atlantic)*
*Natural Resources Canada*
*Bedford Institute of Oceanography*
*Dartmouth, Nova Scotia, Canada B2Y 4A2*

*Postal address: P.O. Box 1006*
*Courier address: 1 Challenger Drive*

*Telephone: (902)426-7732*
*Facsimile: (902)426-4104*
*E-mail:* *epatton@NRCan.gc.ca* [<mailto:epatton@NRCan.gc.ca>](mailto:epatton@NRCan.gc.ca)