David,
It's funny how timing works...I had just read this email from another list I
am on and then came across yours....so I did an old copy/paste job.....
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]>
.. . . . . . . . . . . . . . . . . . . . . . . . . . . .
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
