How to add new columns to datablock
664787Mar 16 2009 — edited Mar 16 2009Hi,
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