Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Fri, Feb 29 2008 11:55 AM	Permanent Link
"Harry de Boer"	Tim, EDB 1.08 (tested in EDBmngr) If I have a view with the statement SELECT * FROM etc. then the view won't run (an error shows) if one of the table's field is altered. Is this correct behaviour? Regards, Harry
Mon, Mar 3 2008 7:02 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Harry, << If I have a view with the statement SELECT * FROM etc. then the view won't run (an error shows) if one of the table's field is altered. Is this correct behaviour? >> Did you change the column type, length, scale, or collation ? If so, then yes, this is correct. -- Tim Young Elevate Software www.elevatesoft.com
Mon, Mar 3 2008 7:27 AM	Permanent Link
"Harry de Boer"	Tim, I did change the column type. Ok so we have to watch out for views (drop and recreate) if we change the structure of a table. Maybe a good thing to mention in the help files! Regards, Harry "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht news:3C45CD77-9143-4639-92E2-69F3645CE0EF@news.elevatesoft.com... > Harry, > > << If I have a view with the statement SELECT * FROM etc. then the view > won't run (an error shows) if one of the table's field is altered. Is this > correct behaviour? >> > > Did you change the column type, length, scale, or collation ? If so, then > yes, this is correct. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > >
Mon, Mar 3 2008 9:51 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Harry, << I did change the column type. Ok so we have to watch out for views (drop and recreate) if we change the structure of a table. Maybe a good thing to mention in the help files! >> I'll make a note to add this. -- Tim Young Elevate Software www.elevatesoft.com