Re: Dependencies

> Not being rude, most people who ask question on the newsgroup has to
> wait avearage of 2 days for an answer and there's nothing more
> discourging then to have someone posted back, NOT willing to help, and
> put in some smart arse comment about 'do it yourself'.

Not to be rude, but this newsgroup does not *owe* anyone anything. And I seriously doubt your average of "2 days for an answer". If you post a question here, you should expect a variety of things to happen, after all this is an unmoderated newsgroup. Among the things that could happen *can* be a long time to get an answer, incorrect answers, and the occasional appearance of a rude answer. You can also get a correct, timely answer which happens in this newsgroup ALL THE TIME.

As for the smart arse comment "about 'do it yourself'", Mr. Morgan was very polite in responding that this was an easy question would could be answered very easily by generating your own test case. Nowhere in your original question did you state that you only had 2 days until the exam. Nowhere in your original question did you state that you were pressed for time and if you had time, you would figure it out on your own. Maybe if you had explained your predicament a little better, you would have gotten a different response.

Mr. Morgan's response was an answer in and of itself and I'm sorry that his answer (and mine) enraged you so much that you felt the need to spend time writing your retort. Time, I might add, that could have been spent finding out the answer to your question. My response was a tangential comment on Mr. Morgan's response. Your newsreader can verify that I responded to his comments, not your question.

> If you not willing to help or 'share your knowledge' on the newsgroup,
> my opnion, DON'T post or reply to ANYTHING - all you are doing is
> discourging the questioner in asking further questions. I believe in
> Trial and errors, but I also believe in a quick help now and then.

I'm sorry Arthur, but you obviously do not pay attention to who answers questions in this newsgroup. There were only two people who replied to your question. Daniel Morgan and myself. If you take a moment to have your newsreader sort by SENDER, you will see that Mr. Morgan has taken lots of time to answer many, many questions. I'm sorry that the time that he spends is "discourging the questioner in asking further questions".

As for myself, I don't pretend to be in the same league as some of the other responders, i.e. J. Lewis, S. Bakker, H. Rogers and the COUNTLESS OTHERS who make this newsgroup a success but I don't have time to enumerate here. And I know that I don't answer as many questions as some other people in this newsgroup. But if you do a little research, you will find that I do answer questions and I do share my knowledge. Part of the knowledge that I was trying to impart on this thread was the soapbox answer of seeing countless people ask questions that could be answered easily if they took the time to perform little test cases. Another thought that I was trying to impart is that learning how to answer your own questions can be a great skill to acquire. Unfortunately, I see too many people looking for the "quick fix" or the answer in a bottle. I did not explicitly state that you were one of these people and I'm sorry if my comments offended you. I was speaking of *some* people in general.

Now....if you have bothered to read down this far, you will find the answer to your question. I hope that it is not too late....

The precedence for objects is (personal object, personal synonym, public synonym). If a view or procedure was created based on a public synonym and an object was created with that same name at a later time, then the view or procedure *may* become invalid. It all depends on wether or not the personal object is nearly identical to the object the public synonym points to. Do they have the same columns? If they differ, then the referencing object will become invalid. If they don't differ, then the referencing object may stay valid.

I would have like to have taken more time to provide you with a simple test case illustrating the above answer, but I have simply spent way too much time writing this response.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================