Home » Developer & Programmer » Forms » Upgrade SQL*Forms v.2.3 to 6i
Upgrade SQL*Forms v.2.3 to 6i [message #78205] Mon, 28 January 2002 09:18 Go to next message
Joe
Messages: 138
Registered: November 1999
Senior Member
I am currently working on a prject where I am upgrading sql*forms version 2.3 to version 6i. The intermediate migration to sql*forms 4.5 was 66% successful.
One of the INP files converted to a sql*forms version 4.5 FMB but I am not able to open it and receive the following error:
FRM-10043: Cannot open file

Does anyone have a detailed checklist on how to successfully perform this sql*forms migration?
How do you convert the v2 style triggers?
How do you convert the exemacro scripts?

If you have a checklist and/or scripts, can you send via email.

Thank you for your assistance.
Re: Upgrade SQL*Forms v.2.3 to 6i [message #78226 is a reply to message #78205] Wed, 30 January 2002 08:00 Go to previous messageGo to next message
Rafael Luciano do Rosario
Messages: 4
Registered: January 2002
Junior Member
Well Joe,
we have a program that converts forms 3.0 in 6.
It was made in C Builder using Forms API.
If you can send me your .inp, I can try convert it to you and send the .fmb back. If I get do this, and it was simple, I can explain you what happens. Other way I have to pass it to my boss, the convertor owner.
We have a project with about 2000 .inps and 500 .rexs to convert.
Maybe we exchange some information. We have found a lot of little details...
I hope can help you.
P.S.: sorry my poor english...
Re: Upgrade SQL*Forms v.2.3 to 6i [message #78228 is a reply to message #78205] Wed, 30 January 2002 08:10 Go to previous messageGo to next message
Joe
Messages: 138
Registered: November 1999
Senior Member
Rafael,

Rafael, I agree, we should share information on these two projects. Let me know if you have any additional information on the software that you are using.

Thank You, Joe

Concuerdo, debemos compartir información en estos dos proyectos. Permita que mí sepa si usted tiene información adicional en el software que usted usan.

Gracias, Joe
Re: Upgrade SQL*Forms v.2.3 to 6i [message #78230 is a reply to message #78228] Wed, 30 January 2002 08:50 Go to previous messageGo to next message
Rafael Luciano do Rosario
Messages: 4
Registered: January 2002
Junior Member
So Joe,
As I said, we developed this software to convert forms ans reports in C Builder, using the Open Forms API.
In the conversion, we do a lot of corrections manupulating the .inp (host commands, mask problems, varchar problems and lot of others).
After it calls "ifcmp60.exe".
And after the .inp is converted in .fmb, we manipulate it using Open forms api to do others corrections like layout (in the canvas), LOV problems and others.
The programs becames very beatiful.
Many corretions are expecificly for our programs, others should happens in any forms/reports.
If you have any doubt, I can try help you. And if you can send you .inp, I convert it to you.
P.S.: you can write only in english, I can understand. But thanks for try the spanish.
Re: Upgrade SQL*Forms v.2.3 to 6i [message #79617 is a reply to message #78205] Thu, 27 June 2002 03:21 Go to previous messageGo to next message
vinay
Messages: 27
Registered: December 1999
Junior Member
I'm in similar project... Any utility or method by which I can convert V2 style triggers to PL/SQL triggers while upgrading Oracle*Forms 3.0 to Oracle*Forms 6i
Re: Upgrade SQL*Forms v.2.3 to 6i [message #79629 is a reply to message #78205] Fri, 28 June 2002 09:26 Go to previous messageGo to next message
Joe Spina
Messages: 1
Registered: June 2002
Junior Member
Hello Vanay,

When working on SQL*Forms conversions from version 2.3 INP files to 6i
fmbs (in addition to version 2 style triggers to pl/sql), I used a tool
called FormsAPI Master available at http://www.orcl-toolbox.com/

The tool will greatly assist with the forms conversions (especially v2
style triggers to pl/sql).

Let me know if you have any additional questions.

Good Luck.

Joe
Re: Upgrade SQL*Forms v.2.3 to 6i [message #79785 is a reply to message #78205] Thu, 11 July 2002 23:47 Go to previous messageGo to next message
Janani
Messages: 3
Registered: July 2002
Junior Member
Hi Joe, We have a tool for converting V2 style trigger into pl/sql trigger and also have tool for migrate forms 3.0 applications into 6i. For more detail, pls. send a mail to us.

Regards

Janani
Re: Upgrade SQL*Forms v.2.3 to 6i [message #80470 is a reply to message #78205] Fri, 27 September 2002 00:58 Go to previous messageGo to next message
Valli
Messages: 2
Registered: September 2002
Junior Member
Hi Vinay
Seen Ur query. Have U successfully converted ur forms to V6i. Could U pl. expalin us what tools you have used?
What all problems you have faced and how did U solve them..
We have a similar requirement. We have to upgrade forms3.0 to 8i..
Any suggestions please...
Re: Upgrade SQL*Forms v.2.3 to 6i [message #80496 is a reply to message #78205] Wed, 02 October 2002 07:19 Go to previous message
Eduardo
Messages: 12
Registered: October 2001
Junior Member
Do you have The Manual of SQL Forms version 2.3 ?
Can you send me it ?

If you can´t, how can I get it ?

Thanks

The programs that I have generated says "Generated by SQL*Forms Version
2.3.31.14.53"

Eduardo M. Mosteiro
T.E. 4333-4117
Previous Topic: Pro*C core dump when using EXEC SQL CONNECT
Next Topic: Disable Button using coding
Goto Forum:
  


Current Time: Thu Feb 29 10:00:30 CST 2024