On Thu, Jul 24, 2008 at 11:20 AM, Claude Schneegans < [EMAIL PROTECTED]> wrote:
> A very particular situation though. Perhaps, but the following demonstrates how this kind of issue can be even more problematic when the table is changed in such a way that no error is thrown by the view... CREATE TABLE tmpTest(foo1 int,bar2 int) GO INSERT INTO tmpTest VALUES(1,2) GO CREATE VIEW tmpView AS SELECT * FROM tmpTest GO SELECT * FROM tmpView --Note the column names and the associated values GO ALTER TABLE tmpTest DROP COLUMN foo1 GO ALTER TABLE tmpTest ADD foo1 int GO UPDATE tmpTest SET foo1 = 1 SELECT * FROM tmpView --Note the column names and the associated values (and no error being thrown) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309645 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
