DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to convert forms in oracle form6i to 10g

  1. #1
    Join Date
    May 2007
    Posts
    7

    How to convert forms in oracle form6i to 10g

    I would like to know about converting forms from oracle form6i to oracle form10g.

  2. #2
    Join Date
    Aug 2007
    Location
    Panama
    Posts
    3
    Note:191529.1
    For Windows

    Forms/Reports 6i

    REM WINDOWS COMPILE FORMS
    ::compile_forms.bat
    cls
    Echo compiling Forms....
    for %%f IN (*.fmb) do ifcmp60 userid=scott/tiger@v817 module=%%f batch=yes
    module_type=form compile_all=yes window_state=minimize
    ECHO FINISHED COMPILING

    REM WINDOWS COMPILE REPORT
    ::compile_report.bat
    cls
    Echo compiling Report .....
    for %%f IN (*.rdf) do RWCON60 userid=scott/tiger@v817 batch=yes source=%%f
    stype=rdffile DTYPE=REPFILE OVERWRITE=yes logfile=log.txt
    ECHO FINISHED COMPILING

    Forms/Reports 9.0.X

    REM WINDOWS COMPILE FORMS
    ::compile_forms.bat
    cls
    Echo compiling Forms....
    for %%f IN (*.fmb) do ifcmp90 userid=scott/tiger@v817 module=%%f batch=yes
    module_type=form compile_all=yes window_state=minimize
    ECHO FINISHED COMPILING



    Forms/Reports 10.X


    ::compile_forms.bat
    cls
    Echo compiling Forms....
    for %%f IN (*.fmb) do frmcmp userid=scott/tiger@v817 module=%%f batch=yes
    module_type=form compile_all=yes window_state=minimize
    ECHO FINISHED COMPILING

    REM WINDOWS COMPILE REPORT
    ::compile_report.bat
    cls
    Echo compiling Report .....
    for %%f IN (*.rdf) do rwconverter userid=scott/tiger@v817 batch=yes
    source=%%f stype=rdffile DTYPE=REPFILE compile_all=yes OVERWRITE=yes logfile=log.txt
    ECHO FINISHED COMPILING

    For UNIX

    Forms/Reports 6i

    #UNIX Forms Compile
    #compile_forms.sh
    for i in `ls *.fmb`
    do
    echo Compiling Form $i ....
    f60genm userid=scott/tiger@bs817 batch=yes module=$i module_type=form
    compile_all=yes window_state=minimize
    done

    #UNIX COMPILE REPORTS
    #compile_rep.sh
    for i in `ls *.rdf`
    do
    echo Compiling Report $i ...
    rwcon60 userid=scott/tiger@bs817 batch=yes source=$i stype=rdffile
    dtype=repfile overwrite=yes compile_all=yes
    done

    Forms/Reports 9.0.X, 10.x

    #UNIX Forms Compile
    #compile_forms.sh
    for i in `ls *.fmb`
    do
    echo Compiling Form $i ....
    f90genm userid=scott/tiger@bs817 batch=yes module=$i module_type=form
    compile_all=yes window_state=minimize
    done

    ( For 10gR1 = forms 9.0.4.x, you can use f90gen also)
    ( For 10gR2 = forms 10.x, you can use frmcmp.sh or frmcmp_batch.sh)

    #UNIX COMPILE REPORTS
    #compile_rep.sh
    for i in `ls *.rdf`
    do
    echo Compiling Report $i ...
    rwconverter.sh userid=scott/tiger@bs817 batch=yes source=$i
    stype=rdffile dtype=repfile overwrite=yes compile_all=yes
    done

    Note: If you dont want to use the X-Display then you can use f60gen,f90gen and frmcmp_batch.sh for compiling Forms. Make sure TERM, ORACLE_TERM and NLS_LANG values are properly set.

    ADDITIONAL:
    You can use the information above to compile libraries or menues or
    convert files from binary to text and text to binary too. eg:
    for %%f in (*.pll) do ifcmp60 userid=user/pwd@db module=%%f module_type=LIBRARY batch=yes window_state=minimize compile_all=yes
    for %%f in (*.mmb) do ifcmp60 userid=user/pwd@db module=%%f module_type=MENU batch=yes window_state=minimize compile_all=yes
    for %%f in (*.mmb) do ifcmp60 userid=user/pwd@db module=%%f module_type=FORM batch=yes window_state=minimize parse=YES
    for %%f in (*.mmb) do ifcmp60 userid=user/pwd@db module=%%f module_type=FORM batch=yes window_state=minimize script=YES
    (and similar loops for Unix).

  3. #3
    Join Date
    May 2007
    Posts
    7

    Hi Aparedes,

    Thank you for your reply. But I do not understand exactly what this code will do. would you please explain me more about that with an example? for example if I have a form (X.fmb) in oracle form builder 6i, tell me how can I convert it to the (X.fmb) in oracle form 10g.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width