Re: Help with DELETE statement via ODBC

Steve Lutz wrote...

> If we are going to turn this into a Philosophical discussion, what
> happens when a select statement updates zero rows? It doesn't cause an
> error, why does a delete?

Hi Steve!

In my previous mail I wrote about DELETE statement because I want
to focus in a specific problem, but I think that the behaviour of
the UPDATE statement is erroneous too. The reasons are exactly the
same as for the DELETE statement. Once again the Sets Theory behind
DBs is the main reason. 0 updated rows must not be an ODBC/DB error.
Maybe 0 updated rows is an application (DB client) error, but that is
a decission of the application. DBs only known about sets of tuples.

Cheers,

+---.---.---.---.---.---.---.---.---+---.---.---.---.---.---.---.---+
| Carlos Abalde (carlos(at)lfcia(dot)org) | http://www.lfcia.org/~carlos |
+ LFCIA Lab, Dept. Computer Science | +34.981.167000 ext. 1275 +
| University of A Coruna, Spain | PGP Key ID = 0x04DF0EAF |
+-.---.---.---.---.---.---.---.---.-+-.---.---.---.---.---.---.---.-+