Forums

ForumForumSearchSearchResultsResults
 
Your search returned 89 result(s):
New Post
 Forum: Bugs
 12/19/2016 11:11 PM  
 
Then the view has become corrupt.  Please use the vwPROJECTS_Edit.2.sql file and recreate the view.  It should be: Create View dbo.vwPROJECTS_Edit as select *   from vwPROJECTS But use the file as it will drop the view and add the select permission.
New Post
 Forum: Bugs
 12/19/2016 2:19 AM  
 
I suspect that the problem is that you previously edited vwPROJECTS and removed the last line of the select fields that was:     , PROJECT_CSTM.* This line instructs SQL Server to include all fields in the custom field table.  New fields are not included until the view ...
New Post
 Forum: Bugs
 12/16/2016 2:50 PM  
 
In SQL Studio, use the stored procedure spSqlRefreshAllViews to recompile the views and get the updated field into the vwPROJECTS view.     exec spSqlRefreshAllViews; You should be able to do the same thing by clicking on Recompile on the Admin page.  But, there could ...
New Post
 Forum: Bugs
 12/15/2016 8:57 PM  
 
You will need to inspect the database in order to determine the status of this field.  Using SQL Studio, first inspect the columns of the table.  It will be in a separate table with _CSTM at the end.  You did not mention the module/table so I cannot be more specific.  If the f...
New Post
 12/9/2016 11:52 AM  
 
We do not have a UI to change the columns, but yes it can be done.  The number of columns is stored in the DATA_COLUMNS of the EDITVIEWS and DETAILVIEWS tables.  You will have to change directly in the database using SQL code or the SQL Server Management Studio. In order to manually ty...
ForumForumSearchSearchResultsResults