Re: any tools to do the following...

From: Satish <satish.kumar_at_oracle.com>
Date: 7 Mar 2003 07:18:42 -0800
Message-ID: <cd30cd73.0303070128.7ce0b745_at_posting.google.com>


Hi,
  How about converting your forms (.fmb) to text format (.fmt) and then do a search and replace the in the text file for the changes to be done and then reconvert the .fmt files to .fmb, this can be achieved by using the forms builder (you could even write a command line script to achieve this by passing arguments to the forms builder exe [ifbld*.exe] )

I would suggest you to check it agaisnt a single form and then inspect for the desired result before going ahead for all the forms.

Hope the solution helps.

Regards
  Satish

kcboyes_at_yahoo.com (Kevin HaleBoyes) wrote in message news:<b37da935.0303050721.5007ce5b_at_posting.google.com>...
> Say I have a table
>
> create table foo (id number, description varchar2(20));
>
> and I create a form based on foo.
>
> I then go in and change the size of the description column to
> be 30. I will have to change the form as well.
>
> Now, imagine that I have 50 tables and fifty forms and a group
> of developers that may make changes to the tables without changing
> the forms. Things are going to get out of sync.
>
> Is there an (semi-) automated way of checking a form against the
> underlying tables? I'm thinking about generating the XML representation
> of the form and parsing that...
>
> If anyone knows of such a checker then I'd love to here about it.
> Thanks,
> Kevin.
Received on Fri Mar 07 2003 - 16:18:42 CET

Original text of this message