thankgodfortektips
Programmer
Hi All,
I know this is the ASP forum and this is more an SQL issue but SQL is working with a ASP App.
I have an ASP application which is working with an SQL 2000 database. The application has been working fine for months and lately I have started developing new areas in it.
Since the new developments I have been getting complaints about errors, sometimes it is that in a table in the asp app the data is from another field i.e. The StartDate data will come under the Name column. Or sometimes the ASP app cant read the data.
I have found the solution but I want to know why it is happening. The solution is to open up the views in Design view, run it, save it, close it... and we are good.
I have been editing the tables that the views are based on, so I assume it is this that is making it go wrong. But is there some kinda maintenance I should be running after adding fields to a table?
Thanks in advance!
I know this is the ASP forum and this is more an SQL issue but SQL is working with a ASP App.
I have an ASP application which is working with an SQL 2000 database. The application has been working fine for months and lately I have started developing new areas in it.
Since the new developments I have been getting complaints about errors, sometimes it is that in a table in the asp app the data is from another field i.e. The StartDate data will come under the Name column. Or sometimes the ASP app cant read the data.
I have found the solution but I want to know why it is happening. The solution is to open up the views in Design view, run it, save it, close it... and we are good.
I have been editing the tables that the views are based on, so I assume it is this that is making it go wrong. But is there some kinda maintenance I should be running after adding fields to a table?
Thanks in advance!
