Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Overwrote Screenset

Status
Not open for further replies.

ultrav

Technical User
Jun 12, 2001
151
US
Macola SQL 7.6.3
I overwrote a screenset(arcusmnt) - what table can I restore it from?

Thanks
Celeste
 
I beleive the table is ARSCRFIL in the Screens DB. One time I was forced to restore the entire screens DB. I was not sure if any other changes were made so I exported the ARCUSMNT.SS and reverted back to the original Screens DB and imported the screen set.
 
Was this a modified screen that you overwrote with the default (MACOLA) screen? It is not possible to overwrite the Macola screenset using the screen designer.

If this is what you are up against you would need to restore the screens database from backup and use SQL Server DTS to transfer data fromnthe backup arscrfil_sql to the current arscrfil_sql. Use a query to do this:

select * from ARSCRFIL_SQL where screen_name<>'<MACOLA'

This will recapture all screens that are modified for screenset ARCUSMNT.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top