I've set up various asp pages which display information from tables in a SQL database. I've created a view which collects the table columns together and this is referenced in my SELECT FROM statement on each asp page.
However, whenever I delete/rename or add a new table column from the view output in Enterprise Manager, it seems to have the side-effect of randomly preventing other columns from displaying data in the asp page.
This is really annoying and I can only reinstate a column if I create a replica with the same data but a different name and change the asp page accordingly.
Perhaps I'm missing something really simple - maybe this is some kind of database setting? Maybe it's some kind of SQL bug? Any suggestions would be much appreciated.
All I'm doing is adding or removing table columns from the view, and this seems to have a completely unpredictable knock-on effect on other columns, preventing the data being displayed in the asp pages.
I can only seem to reinstate columns via a process of trial and error - opening Enterprise Manager and unchecking the output box, closing it down, reopening and checking the boxes again. However, there's always at least one other column that then becomes affected.