Excellent suggestion, Javier!
It would be really nice if the DROP ... command is inserted at the beginning of the file when Unload... option is used via Database Explorer (Forms, Labels and Reports).
On the other hand, if the SYS_FORMS3, SYS_LABELS3, SYS_REPORTS3, SYS_FORMS4, SYS_LABELS4 and SYS_REPORTS4 tables include the UNIQUE KEY, then we'll never have to worry about it. That will keep all of us on our toes <g>.
Very Best R:egards,
Razzak.
At 10:42 AM 9/6/2004 -0500, Javier Valencia wrote:
R:azzak: When in the R:Base Explorer and you right click on a form (say my_form) or report name and select "Unload..." it creates a file with extension FRM such as my_form.RPT plus a file with extension LOB. It would be really nice if the code in the file my_form.FRM would include the line: DROP FORM my_form Or DROP REPORT my_report This would prevent the accidentally loading of a second version of the form (it happens) or report and then you end up with two versions of the same form with the same name but when you try to delete one, it deletes both...I know that good programming practice requires that you drop the form first, but many time when doing development and moving forms and/or reports between test and production databases, it is done from the Explorer rather than from code and it is not uncommon to load a second version of the form or report...
