ousoonerjoe
Programmer
Is it possible to promote all warnings to act as Errors? We have discovered a scenario where a warning will fire, but does not cause an error and in turn causes invalid data to be written to the record. In this particular case, addition between 3 variables and one of them comes up NULL. Any math with a NULL results with a NULL regardless. This causes a warning to fire, but not an error. TRY and CATCH skip right on past these.
The warning states something about Aggregates with NULL result in NULL. Obviously i can do ISNULL for the short fix, but I'd like to get these warnings to act as errors for future issues other than just this one.
Any assistance, tips, or ideas are welcome and appreciated.
Thank you.
--------------------------------------------------
Bluto: What? Over? Did you say "over"? Nothing is over until we decide it is! Was it over when the Germans bombed Pearl Harbor? No!
Otter: Germans?
Boon: Forget it, he's rolling.
--------------------------------------------------
The warning states something about Aggregates with NULL result in NULL. Obviously i can do ISNULL for the short fix, but I'd like to get these warnings to act as errors for future issues other than just this one.
Any assistance, tips, or ideas are welcome and appreciated.
Thank you.
--------------------------------------------------
Bluto: What? Over? Did you say "over"? Nothing is over until we decide it is! Was it over when the Germans bombed Pearl Harbor? No!
Otter: Germans?
Boon: Forget it, he's rolling.
--------------------------------------------------