Quote:
Originally Posted by Old Pedant
If it throws an error, then it's not conformant with ANSI SQL, at all.
ANSI says a DELETE that affects zero records is never an error.
I would be truly surprised if Oracle went against ANSI on something this fundamental.
*********
If you are only looking to see how many records were deleted, most DB interfaces will give you that information.
|
Thanks, Pedant. I didn't think it would, but I've got a weird error when trying to delete a record. Trying to track down what is causing it, and thought that _maybe_ Oracle was erroring if the record did not exist.
__________________
^_^
If anyone knows of a website that can offer ColdFusion help that isn't controlled by neurotic, pedantic jerks* (stackoverflow.com), please PM me with a link.
* The neurotic, pedantic jerks are not the owners; just the people who are in control of the "popularity contest".
|