- Help Center
- Data Management
- Troubleshooting
Lookup or Item list display columns are NULL
Created by: Gunnar Steinn Magnússon
Older versions of exMon (older than 1.5) could, in some cases, set the display columns as null. To make sure all display columns are updated execute this script:
declare @table_id int
declare table_cursor CURSOR FOR
select distinct TableId from dbo.[Table]
OPEN table_cursor
FETCH NEXT FROM table_cursor
INTO @table_id
WHILE @@FETCH_STATUS = 0
BEGIN
print 'Processing table nr ' + cast(@table_id as varchar(5))
EXEC [dbo].[UpdateLookupDisplayColumns]
@LookupTableIdIn = @table_id
EXEC [dbo].[UpdateItemListDisplayColumns]
@TableIdIn = @table_id
FETCH NEXT FROM table_cursor
INTO @table_id
END
CLOSE table_cursor;
DEALLOCATE table_cursor;
Gunnar is the author of this solution article.