Home > Default > When new record instance trigger at Fire Enter Query event is throwing erro

When new record instance trigger at Fire Enter Query event is throwing erro

October 11Hits:8
Advertisement
HI
I have the following code on when new record instance which is set to fire at Enter Query Mode
IF :SYSTEM.BLOCK_STATUS <> 'QUERY' THEN
rec_num:=Get_Block_Property( 'MASTER', CURRENT_RECORD);
GO_ITEM('DETAIL.ITEM_NAME');
CLEAR_BLOCK(NO_VALIDATE);
GO_BLOCK('MASTER');
GO_RECORD(rec_num);
END IF;
But this is throwing error when I am querying record on master block.
It says 'Function not allowed.Please see a list of keys or functions'
Thanks in advance.

Answers

hi,
GO_ITEM( ) procedure is resctricted procedure.It can not be used in Enter Query mode to navigate to an item in a different block.
You can check wheter rest of the procedures are Enter Query Mode -Yes/No thourgh forms help window.
Message was edited by:
Manish.Sharma

Read other 3 answers

Tags:

Related Articles

  • When new record instance trigger at Fire Enter Query event is throwing erroOctober 11

    HI I have the following code on when new record instance which is set to fire at Enter Query Mode IF :SYSTEM.BLOCK_STATUS <> 'QUERY' THEN rec_num:=Get_Block_Property( 'MASTER', CURRENT_RECORD); GO_ITEM('DETAIL.ITEM_NAME'); CLEAR_BLOCK(NO_VALIDATE);

  • FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised unhandled exception ORA-October 11

    Hi, In R12 When trying to search existing users through Sysadmin or any other user ...we are getting the below errror... ORA-01403: no data found FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised unhandled exception ORA-06510 This error is not happe

  • FRM-40735: WHEN-NEW-RECORD-INSTANCE triggerOctober 11

    Hi Guys, Can someone help me to find the root cause of my follwoing issue Issue My Sales Order was giving following error when trying to open the form 'FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger ' Bounced the instance the issue was resolved. Again t

  • FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised unhandled exceptionOctober 11

    I have a form that I migrated to 10g from 6i. I have no problems with it in 6i. When I launch this migrated form on the web in 10g, I get the following error: Error: FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised unhandled exception ORA-03127From

  • Commit_form creating issue with When-New-Record-Instance triggerOctober 11

    Hello friends, I am using Oracle forms 6i . I have a multi-data block. I have written commit_form in when-new-record-instance of the data block. When I launch the form on my instance the form does not open. But when I comment out this code, the form

  • How to populate automatically in a when-new-record-instance trigger?October 11

    I have a form which displays around ten rows with about 5 columns. Whenever i will create a new record, i would like to place an initial value on the first column of every record. How do I do this? If I place the value in the properties of the item,

  • How to undo update of checkbox after triggering when-new-record-instanceOctober 11

    Hi, I am using eBusiness Forms Personalization in 11.5.10 to alter the Receipts form in Purchasing. I want to prevent users checking the rcv_transaction checkbox if the destination is "Multiple" and, instead, click the "+" sign to expl

  • Where's the WHEN-NEW-BLOCK-INSTANCE trigger gone?November 30

    Not a rehash of my famous UKOUG presentation but a genuine question. If I start up a Form with ENTER_QUERY in the WHEN-NEW-FORM-INSTANCE trigger then WHEN-NEW-BLOCK-INSTANCE never fires. I just get a WHEN-NEW-RECORD-INSTANCE. This is true whether the

  • KEY-CERREC TRIGGER IN ENTER-QUERY MODENovember 30

    hi all, i want fire key-crerec trigger in enter-query mode, how it can be done. i am using oracle 10g r2.first: Why did you need such a trigger? In Enter-Query-Mode it is impossible to create new records. second: Forms has a problem with some trigger

  • When-new-record-instanceOctober 11

    Hi All ! I have a form, where in *Trigger:when new form instance* enter_query; *Block level Trigger :when-new-record-instance* :empaply.employeeid:=:global.employeeid; select employee_id,firstname into :empaply.employeeid,:empaply.employeename from p

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.679 s.