It's supposed to be a little better in SQL2K, but at least in SQL7 it's even
worse than this:
Given this structure
TABLE x
column a
column b
column c
TABLE y
column x
column y
column z
create view myview as
SELECT x.a, x.b, y.z from x
Les,
I have also seen this. It's related to using "*" in the view, and then
changing what "*" means by adding or removing columns in a table called by
the view.
To avoid it in the future, take the time to write out the specific fields
you are calling. Otherwise, when you add/remove a field fro
f there's a fix or better workaround.
--Ben Doom
Programmer & General Lackey
Moonbow Software
: -Original Message-
: From: Les Mizzell [mailto:[EMAIL PROTECTED]]
: Sent: Monday, December 16, 2002 2:52 PM
: To: CF-Talk
: Subject: RE: Slightly OT: SQL VIEW gets out of sync??
:
:
I believe with SQL 7, each time when a view is created
('saved'), it saves and maps the underlying schema for
the view, hence, later on, if there's any schema
revision, e.g. a column is added, the new stuff (the
new column) won't be returned by the view.
At least that's the theory, I haven't tested
I've noticed this too...
Seems that the view is stored very specifically and changes to the underlying tables
don't propagate to the view definitions.
Reasons behind the design... I suspect it has to do with performance.
At 11:52 AM 12/16/02, you wrote:
>:> What DB?
>
>MS SQL Server 7
>
~
:> What DB?
MS SQL Server 7
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldf
What DB?
--Ben Doom
Programmer & General Lackey
Moonbow Software
: -Original Message-
: From: Les Mizzell [mailto:[EMAIL PROTECTED]]
: Sent: Monday, December 16, 2002 2:18 PM
: To: CF-Talk
: Subject: Slightly OT: SQL VIEW gets out of sync??
:
:
: Anybody ever seen this before.
7 matches
Mail list logo