[GRASSweb-list]markus: web/grass51/tutorial attrib_storage.html,1.20,1.21
grass at intevation.de
grass at intevation.de
Tue Apr 20 05:42:34 EDT 2004
Author: markus
Update of /grassrepository/web/grass51/tutorial
In directory doto:/tmp/cvs-serv27304
Modified Files:
attrib_storage.html
Log Message:
alter table working now (thanks to Radim)
Index: attrib_storage.html
===================================================================
RCS file: /grassrepository/web/grass51/tutorial/attrib_storage.html,v
retrieving revision 1.20
retrieving revision 1.21
diff -u -d -r1.20 -r1.21
--- attrib_storage.html 1 Mar 2004 08:29:19 -0000 1.20
+++ attrib_storage.html 20 Apr 2004 09:42:32 -0000 1.21
@@ -382,7 +382,9 @@
Then select the ID column and change it's type to "Number" (alias Integer).
Save the table. Now GRASS 5.7 can use the ID column as it is of Integer
type.
-
+<p>
+<b>NOTE: Since April 2004 'ALTER TABLE table ADD COLUMN col type' should work,
+so that 'db.execute' will do the same job to add a column.</b>
<p><table width="100%" cellpadding="3" border="0"> <tr><td align="left"
bgcolor="#B0F0B0"><font color="#00000"><big><b> <a name="OpenOffice"></a>
@@ -417,9 +419,8 @@
Select the column and change the type to "Number" (alias Integer). Save the
table. Now GRASS 5.7 can use the ID column as it is of Integer type.
<br>
-PROBLEM: In OpenOffice 1.0.1 Number/Integer doesn't seem to exist!! So you better
-go with StarOffice.
-
+<b>NOTE: Since April 2004 'ALTER TABLE table ADD COLUMN col type' should work,
+so that 'db.execute' will do the same job to add a column.</b>
<hr>
<P>
Further <a href=links.html>Links</a> (related software, SQL reference etc).
@@ -427,7 +428,7 @@
<!-- FOOTER -->
<p>
<hr>
-<DIV ALIGN=right>© 2002-2003 Markus Neteler<br>
+<DIV ALIGN=right>© 2002-2004 Markus Neteler<br>
<a href="mailto:weblist at grass.itc.it">Comments</a> about this page | <a href="../../faq/index.html">FAQ</a> | <a href="../../download.html">Download</a> | <a href="../../support.html">Support</a> | <a href="../../gdp/index.html">Docs</a> | <a href="../../grassdevel.html">Programming</a> | Back <a href=index.html>5.7 Tutorial Home</a><br>
<i>Last change:
$Date$
More information about the grass-web
mailing list