Current Position:Home > FRM-40737  How can I execute a query in a post block ?

FRM-40737  How can I execute a query in a post block ?

Update:10-11Source: network consolidation
Advertisement
Hi,
I have two blocks based on the same table. Then it is not a 'real' master detail case. The first block contains two fields who are the values in the where clause of the second block. In which trigger or where do I place the EXECUTE-QUERY ? I can't place it in the post-block because post-block don't accept EXECUTE-QUERY and I dont want to use a timer because it bring me some troubles.
Than'k you !

The Best Answer

Advertisement
I have two blocks based on the same table. Then it is not a 'real' master detail case. You can easily create a master-detail here, if your data model allows it. A table can have a foreign key relation to itself. E.g. emp.manager_id if the fk to emp.empno.
  • FRM-40737  How can I execute a query in a post block ? Update:10-11

    Hi, I have two blocks based on the same table. Then it is not a 'real' master detail case. The first block contains two fields who are the values in the where clause of the second block. In which trigger or where do I place the EXECUTE-QUERY ? I can'

  • How to execute the query from different blocks in Forms Update:11-30

    Hi, Curently I have a case where I need to execute the query from some other block. I used l_curr_item VARCHAR2(62) := :SYSTEM.CURSOR_ITEM; Go_Block ('BLOCK2'); Execute_Query; Go_Item(l_curr_item); This works fine , but as I am using Go_Block it does

  • Go_item(:detail.item) after query(F7) in master, frm-40737 Update:11-30

    Dear friends, I have a master block and a detail block. When the master block ist queried, I want to go to a disticnt item in detail block, if there are records. Therefore I tried to put code in the post_query of the detail_block, which caused error

  • I am getting frm :40737 because go_block Update:11-30

    Hello World, I have a form with master block and details , the detail block as a tabular. I want the detail block to track the changes on the master , like if the user updated on a particular item on the master the detail keep the username and date.

  • FRM-40737: illegal restricted procedure COMMIT in POST-TEXT-ITEM trigger Update:11-30

    Hi All, I tried to execute an insert statement in a POST-TEXT-ITEM trigger and use commit to save data in the db but this error appeared: FRM-40737: illegal restricted procedure COMMIT in POST-TEXT-ITEM trigger How to solve it? OR how to save every t

  • Suppress the enter-query mode when no-data-found after execute a query. Update:11-30

    HI, Greetings of the day, Can any one suggest me that how to Suppress the enter-query mode when no-data-found after execute a query on the form by a button. whenever i execute query on form and result is no data found then form :system.mode is still

  • Error while executing a query Update:10-11

    Hi, While executing a query in portal it is giving internal server error. In the input screen help, we are searchign using wild card characters.I.e "  141",its giving internal server error, If we are giving the one value/no value the report is e

  • GO button to execute a query once report parameters are selected. Update:10-11

    I am familiar with the GO button depicted in chapter 10 of the 2 Day Developer manual that does not cause the report to be rendered until a user chooses a value from a select list of values. The GO button is used in conjunction with Null Value Text (

  • Can I stop a report from Re-executing the query when I go back to that page Update:10-11

    I have a report that has a complicated query and looks at a lot of information to display the results. This query then links of to show details of individual items that were displayed in the result. But when I hit the back button on the browser, it e

  • How Can I Execute Sql Query in Managed bean? Update:10-11

    Hi, I want to execute sql query in managedbean and get the query result. How can I do? Best wishes!You can do this by having current Database connection your application is using like this public static synchronized DBTransaction getDBTransaction(){