We have a database that we are required to hide the design by checking “Hide formulas and Lotus Script” when a design replacement is done.
Until recently, this has not caused any problems. However, now we are finding that some of the database’s functions that are coded in the database no longer work when the design is hidden. When the design is not hidden, the funtions’ code works fine.
We have verified that none of the design elements (forms, agents, etc.) have “Prohibit design refresh or replace to modify” checked.
We’ve also tried doing a replace with a blank template and then again with the actual template, hiding the design and still the functions don’t work.
Can anyone help us with this problem??? We despartely need help.
Subject: Do you use the same data and error handling?
Are you sure you use the same data and the same environment for both databases?Do you use error handling in your code for specification of the problem cause?
Sometimes when you hide the design it doesn’t works in the same way as the original template. This is an usual issue.
Sometimes we had to change the code just in order to check that it works with the hidden design , but most of the times we can fix the problems in this way:
Always replace the design with the blank template.
Before replace the design with the new template make sure that there is no other design element in the template, usually can be views with the “Prohibit desing refresh” property checked. Delete all of them. Just keep one.