SQL UPDATE statements (confused again)
sarahr at genesearch.com.au
Wed Jun 2 00:12:43 CDT 2004
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.
More information about the use-livecode