Hello Everyone,
I would appreciate input from anyone as to how developers have automated
customization of SQL*Forms. Egs. if there are SQL*Forms forms in a *.inp
files and in the Forms designer table in the database and there is a need to
add the same code to many forms. How does one automate it ?
I have seen developers use the following:
- Manually apply it.
- Write tools using programmable editors to apply changes to the *.inp files.
egs. in VAX/VMS environment use TPU (text processing utility).
- Write tools which will generate key script input file and then apply
these changes using the designer ( sqlforms -r <key script file> ) and
one of the useful tools in the designer would be the copy object command.
Are there any other ways to do this ?
Where would one use it ?
There is need if the SQL*Forms code is generated by a CASE tool and if a
given requirement can only be met by modifying the form and this change has to
be applied to many forms.
Is there any option within the Oracle CASE tool to do the same ? (Excuse my
ignorance)
Thanks in advance.
