Xref: alice comp.databases.oracle.tools:12337
From: bsteele@hillbilly.com (Biff Steel)
Newsgroups: comp.databases.oracle.tools
Subject: Automate your Forms 3 to Y2k Compliance
Date: Tue, 05 May 1998 13:35:22 GMT
Lines: 19
Message-ID: <354f13b2.843509702@news.alpha.net>
X-Newsreader: Forte Free Agent 1.11/32.235
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!news.he.net!pacifier!homer.alpha.net!not-for-mail

As part of a project to convert a client's forms 3 forms to support
the year 2000 we have developed an automated process to convert your
forms. It will implement the code to allow users to enter and query
dates such that they will always be saved to the database as the year
closest to the year 2000 (1950 - 2050).  The program will NOT fully
convert your forms. If you have some types of date math and date
comparisons in PL/SQL code in triggers, this program will not convert
the code. We can however identify suspect code and show you how to
convert it.  

We have decided to sell this service at prices well below what it
would take to have a programmer do the work manually. And since we
have tested it on over 400 forms in an > 100 million dollar / yr
manufacturing plant with full accounting applications, we have found a
number of subtle issues that you won't easily find and these issues
are not covered in the Oracle white paper available on their web-site.

If you are interested in automating your conversion of forms 3 to Y2K
compliance. Contact me at jmoran@baraboo.com.