Re: Forms 2.3

Hello,

[Quoted] Although Oracle provides a tool that can convert Forms 2.x to Forms 3, I'm not sure if that's a such a good idea. There is no conversion of triggers, so you will still have Forms 2.3 syntax in your Forms.
So before you do this, be sure that you can use 2.3 trigger syntax in Forms 4.5. I don't know if that's possible, or if there is a performance loss.
The Oracle online help says:

     If I upgrade from SQL*Forms 2.3 to Forms 4.5, what
     becomes of my V2 style triggers ?

    Answer

     The upgrade process from 2.3 to 4.5 is done via the
     Forms Generate option.  This is similar to the upgrade from
     2.3 to 3.0 and all V2 style triggers are not altered.

     You can leave these as they are with no problems, although
     we normally recommend that you replace any "select ... from
     dual" statements with PL/SQL procedural logic, as this will
     improve performance.

Copyright (c) 1994, Oracle Corporation.

I know of a tool that claims it can convert 2.3 triggers to PL/SQL, but I'm not sure what company sold it, or if they still sell this product, and I have no experience with it.
(I think it was Comtecno, now USoft, in Naarden, the Netherlands)

Peter de Vries wrote:

> Hello all.
>
> One of my clients is still using a few applications developed
> with SQL*Forms 2.3
>
> The plan is to upgrade these forms to a GUI environment.
> Although I am fairly familiar with forms 2.3, to my knowledge
> there is no easy way to do this.
>
> I will probably have to start from scratch in Developer, or I
> may be able to upgrade to forms 3.0 and take it from there
> with a conversion tool in Developer.
>
> My question is this:
>
> Is there a way to upgrade these applications to forms 3.0 without
> losing too much of the original source?
>
> Hints, tips and/or suggestions are welcome.
>
> Thanks
>
> Peter de Vries.
Received on Fri Feb 19 1999 - 13:25:25 CET