song2siren
Programmer
Hello
I've set up a view in Enterprise Manager which draws together data from various tables.
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 my 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. Yet there's always at least one other column that then becomes affected.
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.
I've set up a view in Enterprise Manager which draws together data from various tables.
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 my 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. Yet there's always at least one other column that then becomes affected.
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.
