SQL*Forms V3 problem #2

SQL*Forms V3 problem #2

We just upgraded from Oracle V6.0.34 (Forms ) to Oracle V6.0.36.5 (Forms ) and have encountered a problem with 'list of values' and the ENTER routine.

On the screen the user enters an initial and the LOV pulls up all audiologists with that initial; the user then selects the one they want; the original screen displays and the audiologists details appear in the appropriate fields with the special audiologis_id key a hidden field.

The user then presses the COMMIT key to action the request (forces a print to a file); the request does an ENTER which causes the ON_VALIDATE trigger to check the audiologist_id against the database and if valid then prints the information. Well that's how its supposed to work.

When the user presses COMMIT they get a validation error. However, if they press the RETURN key prior to pressing COMMIT .. it works.

What's happening?

Another form is getting a similar problem but it appears that the returned key is losing a digit when it gets returned from the LOV routine. Again, this was a working form prior to the upgrade and in fact works client/server from a V6.0.34 database client to the V6.0.36.5 server database.

We held off going to V6.0.34.#, V6.0.35.# and V6.0.36.# because Oracle advised us there were problems with those release that were fixed in V6.0.36.5. Silly me.

Has anybody else had similar problems with this Oracle release?

As a result of this problem we will not be upgrading from V6.0.34 to a later V6.0.# release. We will wait until Oracle V7 arrives.

-- 

Bruce...        pihlab_at_hhcs.gov.au

"If you swallow a live frog first thing in the morning ...
 Nothing worse will happen to either of you for the rest of the day."

*******************************************************************


* Bruce Pihlamae  --  Database Administration                     *


* Commonwealth Department of Health, Housing & Community Services *

* Canberra, Australia                             (W) 06-289-7056 *

*******************************************************************


* These are my own thoughts and opinions, few that I have.        *


*******************************************************************