Re: [GENERAL] how to modify a view

2008-05-21 Thread J. Manuel Velasco - UBILIBET
Thank you Shane All beings be happy, ·_- manou Shane Ambler escribió: J. Manuel Velasco - UBILIBET wrote: Hello, The DB I am using has views. I need to modify the view adding one field to the QUERY that build the query. When I edit the VIEW and add the field, I g

Re: [GENERAL] how to modify a view

2008-05-20 Thread Reece Hart
On Wed, 2008-05-21 at 02:43 +0930, Shane Ambler wrote: > Yes - The only way to do it is DROP VIEW... then CREATE VIEW... - the > catch is any other views that depend on the view you wish to drop. Tip: It's sometimes useful to rename an existing view or table to deprecate it. (I use names like _s

Re: [GENERAL] how to modify a view

2008-05-20 Thread Shane Ambler
J. Manuel Velasco - UBILIBET wrote: Hello, The DB I am using has views. I need to modify the view adding one field to the QUERY that build the query. When I edit the VIEW and add the field, I get the error that tells me "It's not possible to change columns number in a view" So, do I need to re