Subject Dependancies not enforced
Author Jason Dodson
Hey all,

Just this morning, I noticed a flood of error messages coming from my Web server. A certain stored procedure I was
running was causing an "Index Unexpectedly Deleted". What I come to find out is, there are fields referenced in said
stored procedure which had changed datatypes (mostly numeric(something) -> Double Precision). Obvioulsy, there were no
dependency errors when these fields changed, and I am perplexed as to why...

On top of this, I needed to remake/alter said stored procedure to reflect the new field types. I was thinking, I
SHOULDNT be able to drop this procedure because a few calculated fields are dependent on it. But sure enough, I was able
to drop it and readd it without a complaint from the server. Everything works fine now, but I am a little worried that
something might be wrong with either my DB, or firebird itself.

Ideas are welcome.

Jason

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.