Also, can you explain what some of the unexpected results might be?
Hi Gary,
I've often experienced unexpected result. A typical issue, for example, occurs when you change the order of the columns on underlying views/tables of a view that use "SELECT *" (but not only with *! Also with explicit columns list!). For example if you add a new column on the underlying tables/views, expecially if you add that column in the middle and not at the end of the column list.
This is what happens to me more often.
I don't know if ther are other kind of issues... perhaps Cameron can describe to us other cases.
Bye!
Flavio.