Re: SQL Server 2000 warning

[David Cummins]

Yeah, bizarre coincidence! BTW, sorry if my post was a little strong, just had
clients hassling me about it, and needed to pass it on! ;)

David Cummins

Janine Jakim wrote:
> 
> David,
> It's funny how timing works...I had just read this email from another list I
> am on and then came across yoursso 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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Server 2000 warning

[Janine Jakim]

David,
It's funny how timing works...I had just read this email from another list I
am on and then came across yoursso 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] 
.. . . . . . . . . . . . . . . . . . . . . . . . . . . . 

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists