<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<DEFANGED_meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
I think that's because SELECT is for access the date while EXECUTE is
for manage the data.<br>
So if you want to delete, update or insert some data db.execute is the
right command, <br>
while for extract and query the data db.select is the right one.<br>
<br>
Cheers,<br>
Maxi<br>
<br>
<br>
David Finlayson wrote:<br>
<blockquote type="cite"
cite="midbe6d1720506211058476c7a30@mail.gmail.com">
<pre wrap="">I have been learning the GRASS SQL commands and don't fully understand
why there are individual commands for some SQL statements and not
others (for example why not just have db.execute?). In fact, I have
found some SELECT statements don't work in db.execute but do work in
db.select. This seems a bit confusing to me.
David
On 6/21/05, Moritz Lennert <a class="moz-txt-link-rfc2396E" href="mailto:mlennert@club.worldonline.be"><mlennert@club.worldonline.be></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On Tue, June 21, 2005 18:40, Aldo Clerici said:
</pre>
<blockquote type="cite">
<pre wrap="">Dear GRASSusers,
does it exist the db.droptable command?
It is described in the GRASS GIS Reference Manual and in many tutorials, but
it seems not to exist in my GRASS version (6.1.cvs).
</pre>
</blockquote>
<pre wrap="">Currently it does not exist. The recommended way of dropping a table is:
echo "DROP TABLE fmacopy" | db.execute
However, it wouldn't be too difficult to create a db.droptable if there is
real demand.
Moritz
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Eng. Massimiliano Cannata
Scuola Universitaria Professionale della Svizzera Italiana
Istituto Scienze della Terra
Via Trevano, c.p. 72
CH-6952 Canobbio-Lugano
Tel: +41 (0)58 666 62 18
Fax +41 (0)58 666 62 09
</pre>
</body>
</html>