Comparing Oracle Forms modules

compare oracleforms
rbrayb picture rbrayb · Jan 22, 2009 · Viewed 7.2k times · Source

We've inherited a large Oracle project that was originally Oracle 9 and is now Oracle 11.

We don't have much confidence in the Forms change register.

Are there any tools we could use to compare the two Forms projects?

(By virtue of the fact that two different versions of Forms are involved, there will be differences even though the underlying code hasn't changed).

Answer

Thomas Jones-Low picture Thomas Jones-Low · Jan 23, 2009

The general consensus of the Oracle Tools Developers Users Group is that the ORCL Toolbox FormsTool diff ability is the best and brightest. Well worth the cost of a license if you have a diff need for form.

The problem with the FMB->FMT is that the queries in the forms are converted to a binary format which is unreadable by humans.

Forms version 10 has an ability to convert FMB to XML files, assuming you can read the XML files and do diffs.

Don't assume that just because you are using two versions of forms, the the underlying FMB files need to change. I've taken FMB files for Forms 4.5, and run them through the compiler for the Forms 4.5, 6i and 9i and gotten all of them to work just fine.

Which versions of Forms are you using?

Related questions

Compare two dates with JavaScript

Can someone suggest a way to compare the values of two dates greater than, less than, and not in the past using JavaScript? The values will be coming from text boxes.

Read More
How do I check for null values in JavaScript?

How can I check for null values in JavaScript? I wrote the code below but it didn't work. if (pass == null || cpass == null || email == null || cemail == null || user == null) { alert("fill all columns"); return false; } And how can I find …

Read More
Query comparing dates in SQL

I have a table with dates that all happened in the month November. I wrote this query select id,numbers_from,created_date,amount_numbers,SMS_text from Test_Table where created_date <= '2013-04-12' This query …

Read More