What version of SQL Server are you using?
-----Original Message-----
From: Marc Funaro [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 5:45 PM
To: Fusebox
Subject: OT: SQL view refresh
Hi All,
I am the king of OT posts this week, but y'all know yer stuff, so...
Every time I change a SQL Server TABLE, any VIEWS associated with that table
are f***ed up until I open the view, make a small change (like add or delete
a line at the bottom of the SQL code in the view), and save the view. This
is especially noticeable when I add or remove table colums.
IS THERE ANY WAY TO FORCE A VIEW TO "REFRESH" after a change to a table upon
which it is based? I have one table that is the basis for five different
views, and each time I have to go and play with those views after I make a
change to the table, even thought the change I make does not directly affect
the "output" of any of those views.
Thanks,
... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Marc Funaro, President
Advantex Technical Consulting Services
5547 State Highway 12
Norwich, NY 13815
Phone: 607-336-6895
Fax: 801-383-4864
Internet: http://www.advantex.net
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
