Re: Migrating SQL*Forms 3.0 to Forms 4.5, 5 or 6

"Peter L" <news_at_abc.co.uk> wrote in message news:397e129d.24501846_at_news.freeserve.net...
> On Tue, 25 Jul 2000 19:12:23 GMT, hosia_at_lut.fi (Tuomas Hosia) wrote:
>
> >"barbye" <barbye_at_tiscalinet.it> kirjoitteli seuraavaa:
> >
> >>Hi.
> >>
> >>Has anybody any experience of migrating SQL*Forms 3.0 to Forms 4.5, 5 or
 6.
> >
> >Yes.
> >
> >First to 4.0 and later 4.5 and these were migrated further to 5.0.
> >
> >3.0 was on DOS-platform and conversion was made to windows-platform.
> >
> >Automatic conversion usually can convert functionality but
> >unfortunately it can't make neat looking end result or convert
> >triggers to pl/sql.
> >
> >Oracle recommends that triggers should be rewritten to pl/sql and I
> >think it's a good idea. Pl/sql-triggers are usually much simpler and
> >much easier to comprehend.
> >
> >
> Forms 3 allows PL/SQL triggers. Wasn't it the move from 2.3 to 3.0
> that had this problem?

Yes they did but you could convert 2.3 forms to 3.0 forms without changing the triggers.

I have converted forms 3.0 to 4.5 and up for three customers. The 4.5 forms compiler has a section for converting 3.0 forms to 4.5. After the conversion, if there are no 2.3 triggers you will have a character based form. I recommend that you use a template and copy the information into the template to make the forms GUI.
There is a template form that I used at
http://ourworld.compuserve.com/homepages/Peter_Koletzke/tip.htm

under Forms 4.5 VRAD Template. This is a zip file with the instructions included on how to set this up. Received on Tue Jul 25 2000 - 00:00:00 CEST