Press "Enter" to skip to content

Populating Display Item Value On Query In Oracle Forms

Write Post-Query trigger for the block you want to fetch the field value for display item.


   Select Ename into :datablock.dspname
      from emp
      where ecode = :datablock.ecode;
   — Field dspname in datablock will be populated with the value
   when others then
   — you can ignore error 

You can write multiple plsql blocks in post-query trigger for different tables.

Vinish Kapoor is created, written, and maintained by Vinish Kapoor. It is built on WordPress, and hosted by Bluehost. Connect with Vinish on Facebook, Twitter, and GitHub.

You may also like: