Re: Forms 3.0 -> 4.5

From: Leo Albers <Leo_G_Albers.rxv_at_eur.xerox.com>
Date: Fri, 22 May 1998 10:02:52 GMT
Message-ID: <35654D4C.41C67EA6_at_eur.xerox.com>

danlin_at_my-dejanews.com wrote:
>
> Hi!
>
> We're currently in the process of starting a project where we will convert a
> small application from SQL*Forms 3.0 to Forms 4.5.
>
> The problem we have is that we don't know of anyone who has done such a thing
> before. Also, this project is too small to use the products of Kumaran and the
> like.
>
> We are therefore looking for some kind of documentation or model which would
> clarify pitfalls and possible problems which can/will arise when using the
> Generate function in Forms 4.5, and which would adress best solutions.
>
> If you know of anything like this I would appreciate if you would contact me
> by e-mail promptly.
>
> Regards,
>
> Dan-Erik Lindberg
> SysTeam, Sweden
>
> You can reach me at dan-erik.lindberg (at) systeam.se
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading

################################################################################

Dan-Erik,

To convert character-base to character-based you have two(2) options:

1. FILE-TO-FILE CONVERSION Doc: SQL*Forms 3.0 .inp file to Forms 4.5 .fmb and .fmx file. This option generates Forms 4.5 files (.fmb and .fmx) which runs and shows identical as a SQL*Forms 3.0 file. The .fmb file can be loaded into the Forms 4.5 repository at any time. Using the default terminal map only a few keys differ from SQL*Forms 3.0 key-mapping (vt220).

   How: f45gen module=<.inp filename> \
               userid=<uname/pword>   \
               module_type=FORM       \
               module_access=FILE     \
               logon=YES              \
               upgrade=YES            \
               insert=NO              \
               version=30             \
               generate=YES           \
               batch=NO               \
               statistics=NO

2. FILE-TO-REPOSITORY CONVERSION
   Doc: SQL*Forms 3.0 .inp to Forms 4.5 repository.

        This option convertes 3.0 to 4.5, stores the data in the 
        repository and generates Forms 4.5 .fmb file.
   How: f45gen module=<.inp filename> \
               userid=<uname/pword>   \
               module_type=FORM       \
               module_access=DATABASE \
               logon=YES              \
               upgrade=YES            \
               insert=YES             \
               version=30             \
               generate=YES           \
               batch=NO               \
               statistics=NO

NOTES

---

. SQL*Forms 3.0 LIBRARY FORMS must be converted first and must be   converted using option 2 (FILE-TO-DATABASE). . The command lines below are used on Unix. . Start Forms 4.5 Designer, open a converted form, open the 'Layout Editor...'
  and be supprised ?! ...ruler numbering is based on 80*24 !

CREATE ASCII FILE

---

On top you can generate an ASCII file (.fmt).

   How: f45gen module=<.inp filename> \
               userid=<uname/pword>   \
               module_type=FORM       \
               module_access=FILE     \
               script=YES

EXECUTE FORMS 4.5 CHARACTER-BASED FORM

---

f45run module=<.fmx filename> userid=<uname/pword>

I hope this answers your question.
Regards and good luck !

Leo Albers
EDS Venray
Netherlands Received on Fri May 22 1998 - 12:02:52 CEST