Macola Screensets Listing

[vanessa03]

Is there an easy way to determine what screens have been changed? Are the changes in some table?
Thanks,
Vanessa

 

[kscheeler]

If you are running Macola on SQL Server, copy the following script into query analyzer and run it. You'll have to change the FROM line for the module that you want to look at. This one is looking at the AR module for custom screens.

use screens
select screen_id, screen_name
from arscrfil_sql
where screen_name <> 'MACOLA' and
screen_number = 1
order by screen_id, screen_name

Kevin Scheeler

 

[TLeaders]

Here is another script to return modified screen sets. As with Kevin's copy this code to query analyzer and run it. This script is for 7.6 in you need an ES script let me know and I will post it.

Tom

use screens
DECLARE @iname varchar(20)
DECLARE @sqlcode varchar (200)
DECLARE table_cursor CURSOR FOR
select name from sysobjects where name like '%%scrfil_sql'
OPEN table_cursor
FETCH NEXT FROM table_cursor INTO @iname
WHILE (@@fetch_status = 0 )
BEGIN
set @sqlcode = 'select * from ' + @iname + ' where screen_name <> ''MACOLA'' and screen_number = 1'
print @sqlcode
Exec (@sqlcode)
FETCH NEXT FROM table_cursor INTO @iname
end
DEALLOCATE table_cursor

 

[vanessa03]

Thanks,
Sorry I didn't reply sooner. I been out from work until today. That worked perfect.
Vanessa