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 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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