CODEWITHSUNDEEP
oracle-databaseformsoracle-apex
ignite-me
ignite-me

Reputation: 778

Oracle Application Express - Form Fields not Populated with Data

By default, when creating an application with Report + Form pages, you would get something like this (and I initially did):

Report Page

enter image description here

Form Page (when pencil is clicked on the Report Page)

enter image description here

This is what my Form Page looks after making some changes to the application

enter image description here

Form fields are not being populated anymore, even though data source is set as a corresponding database column for every field. Does anyone have a clue why the values are suddenly not showing anymore? Which attributes are responsible for displaying data on a Form Page?

Upvotes: 0

Views: 1235

Answers (1)

Cristian_I
Cristian_I

Reputation: 1625

When you click on the edit pencil in your report Apex sends you to the form page with a parameter that uniquely identifies the record that you want to edit. This parameter can be the Primary Key or the RowID. You can see this in the URL of the Form page that will look something like this: apex.somewhere.com/pls/apex/f?p=4350:1:220883543::::ROWID:AAAAECAABAAAAgiAAA

Most probably you are not sending the parameter from the Report to the Form page. Go on your Report, click on Attributes and at the Link Attribute be sure to set your ROWID(or PK) from Form Page with the value of the ROWID from the Report Page. Something like in the below img (3 is my form page in this example):

enter image description here

Upvotes: 3

Related Questions