Thursday, August 6, 2009

Is It Required to Recompile Forms/Reports When Connecting to a New Database Instance?

It is recommended to recompile all forms and reports when connecting to a new RDBMS.

1) This will act as a health-check to confirm that all dependent RDBMS objects are present andvalid. (Review the compile output for any errors)

2) Timestamps of RDBMS objects may be newer than the depending forms/reports objects.

3) If the new RDBMS uses a different schema to house database objects, the reference in thecompiled forms/reports will no longer be valid, and problems will occur.

4) The recompilation can be done using a batch script, so it is not required to spend timerecompiling each form/report manually

No comments: