SQL UPDATE statements (confused again)

[Sarah Reichelt]

On 2 Jun 2004, at 12:55 am, K wrote:

> Confused again!  Okay revdb_execute return the number of rows 
> modified.  This would make a 0 (zero) return value  a indeterminate 
> state.  Since one cannot tell if 0 (zero) rows where modified or if a 
> error occured preventing the statement from executing.  How does one 
> tell the difference?
>
I can't test this at the moment, but are you sure an error returns 
zero? I had thought that if the result was a number, the command had 
executed correctly and the result was the number of rows modified. If 
there is an error the result will be more than just a single number. I 
may be wrong, but it is an idea for you to check out.

Cheers,
Sarah