Example is given below to create a data block based on From Clause query in Oracle Forms. The following are the steps:

Create a data block manually and set the following properties:

You can specify different query as per your need.

Then create the items in that block as shown below (or create as per your need):

Note: Item names should match with the column name you specified in From Clause Query.

Set the property of each item (textitem, listitem etc) as shown below:

Note: For From Clause Query block on item should be set as Primary Key, check the example is given below:

Then set the Primary Key for EmpNo field as shown in below example:

Now you can run the form and execute query to display the records as shown below, you can download this form formclause.fmb from the following link FromClause.FMB:

Oracle Forms Recipes eBookDownload

Learn how to create data block based on from clause query in Oracle Forms.

Post a Comment

V. Kapoor

{picture#https://3.bp.blogspot.com/-q3wCssWUHo8/ViDFfCpPEuI/AAAAAAAAD0M/MHPvgnl3T3U/s1600/authpic.JPG} Vinish Kapoor is a Software Consultant, currently working in a reputed IT company in Noida, India and doing blogging on Oracle Forms, SQL and PLSQL topics. He is an author of an eBook Oracle Forms Recipes, which is available on Google play. {facebook#https://www.facebook.com/foxinfotech2014} {twitter#https://twitter.com/foxinfotech} {google#https://plus.google.com/u/0/+VKapoor/posts}
Fox Infotech. Powered by Blogger.