Home » Developer & Programmer » Forms » automate forms conversion. (6i,10gas ,xp ,RHEL 4)
automate forms conversion. [message #296755] Mon, 28 January 2008 23:46 Go to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
I am in a process to migrate the forms and reports 6i to 10G AS.
The first thing to do is to make the forms and reports compile in 10G AS.
The first thing to do is to replace CALL built in with CALL_FORM.

Since there are hundreds of forms,Is there any automated way to replace the above built in or do i have to do it manually one by one tediously?
Re: automate forms conversion. [message #296797 is a reply to message #296755] Tue, 29 January 2008 01:43 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I used Search and Replace; it is a program ...
Quote:
... for finding text in files and performing advanced search / replace operations on text or binary files using grep style regular expressions. The many features include searching files in ZIPs, HTML mode, clipboard search/replace, & more

Perhaps you'll find it useful.
Re: automate forms conversion. [message #296805 is a reply to message #296755] Tue, 29 January 2008 02:07 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Would it work on linux?
Re: automate forms conversion. [message #296808 is a reply to message #296755] Tue, 29 January 2008 02:17 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
It does not recognize fmb files in windows
Re: automate forms conversion. [message #296809 is a reply to message #296808] Tue, 29 January 2008 02:29 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It does on my Windows XP SP2 (using Search and Replace 5.1)

./fa/3826/0/
Re: automate forms conversion. [message #296820 is a reply to message #296755] Tue, 29 January 2008 03:10 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
I need to change CALL with CALL_FORM in the code in the various triggers in fmb files.
I don't see it doing this.
Re: automate forms conversion. [message #296855 is a reply to message #296755] Tue, 29 January 2008 06:10 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
I wrote a shell script to automate the process.

#!bin/bash
mkdir temp
for file in $@
do
sed 's/call/call_form/g' $file > temp/$file
mv temp/$file $file
done


but i forgot that plsql is written behind the file.
And fmb files are binary files.
So this won't work for fmb files.
Does any one know how to modify it to solve the purpose?

Re: automate forms conversion. [message #296863 is a reply to message #296820] Tue, 29 January 2008 06:23 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
varu123 wrote on Tue, 29 January 2008 10:10
I need to change CALL with CALL_FORM in the code in the various triggers in fmb files.
I don't see it doing this.


I don't have any 'CALL' in my forms to change it to 'CALL_FORM'. So, I changed 'ocit' to 'al_me_gnjavis'. Do I need to create a form which will show you an exact example of what you'd like to see?

./fa/3830/0/
Re: automate forms conversion. [message #296873 is a reply to message #296755] Tue, 29 January 2008 06:47 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
But in the form,i do not see the changes.
Re: automate forms conversion. [message #297034 is a reply to message #296873] Tue, 29 January 2008 23:36 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you considered using Oracle's Migration Assistant? For more information search for 'Migration Assistant' on either this site, Oracle's main site, or google.

David
Previous Topic: FRM-40102 while calling new form in between a multi record block
Next Topic: Menu attached to a form appears on MDI Window in 10g !!
Goto Forum:
  


Current Time: Sat Dec 10 05:01:33 CST 2016

Total time taken to generate the page: 0.09248 seconds