Upgrade SQL*Forms v.2.3 to 6i [message #78205] |
Mon, 28 January 2002 09:18 |
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 |
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 |
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 |
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 #79629 is a reply to message #78205] |
Fri, 28 June 2002 09:26 |
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 |
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 |
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 |
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
|
|
|