Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to add new columns to datablock

664787Mar 16 2009 — edited Mar 16 2009
Hi,

I am new to oracle forms.

Can you gurus out there help me with a simple query.

I've a data block based on system_parameters table.

I've to add two new text items corresponding to two new columns (let say A & B) added in the same table.

I've added the text items manually on the layout editor of the data block.

In the property pallette under the database section i've given column name as A & B (new column name of the table).

When i am running the form, it gives me FRM-40505 (Unable to perform query).

I know, the new text items have to be associated with system_parameters.A and system_parameters.B..

Are there any more things which need to be done in order to reflect the two new columns on the scree?

Any help will be greatly appreciated.

Regards,
Navnit
This post has been answered by François Degrelle on Mar 16 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2009
Added on Mar 16 2009
4 comments
3,369 views