Forms 6I oddity
From: guycorbett_at_my-deja.com <(guycorbett_at_my-deja.com)>
Date: 11 Feb 2002 06:27:39 -0800
Message-ID: <ad029fc8.0202110627.718cd37c_at_posting.google.com>
I am updating a forms application from Oracle 7/F45 to Oracle 9I/F6I. I cannot see why a piece of code which works ok in the old environment will not work in the new.
A form calls another using:
Date: 11 Feb 2002 06:27:39 -0800
Message-ID: <ad029fc8.0202110627.718cd37c_at_posting.google.com>
I am updating a forms application from Oracle 7/F45 to Oracle 9I/F6I. I cannot see why a piece of code which works ok in the old environment will not work in the new.
A form calls another using:
open_form(FmxName, ACTIVATE, SESSION, ParamListID);
The called form's WHEN-NEW-FORM-INSTANCE trigger calls a program unit whih has the code:
IF UPPER(name_in('PARAMETER.OPEN_ACTION')) = 'PASS_FK_QUERY' THEN
IF name_in('PARAMETER.ENTRY_ID') IS NOT NULL THEN
set_block_property('COMPOUND', DEFAULT_WHERE, 'entry_id = ' || name_in('PARAMETER.ENTRY_ID') || ' and delete_marked_date is null'); message('g1');message('g1'); go_block('COMPOUND'); message('g2');message('g2'); CheckPackageFailure; execute_query;
(Normally without the messages) On the first call message g1 is displayed and than the user is returned to the calling form, any subsequent calls work correctly. If a message is inserted in the calling form before the open_form the call works correctly every time. Has anyone got any suggestions as to what is going on? Received on Mon Feb 11 2002 - 15:27:39 CET