Re: Adding a field to Oracle Forms 4.5

Antonio Tortora <antoniot_at_iwaynet.net> wrote:

>Hello
>
>This one has me stumped.
>
>I have create a table and then design the forms screen. The Interaction
>with the form and the table works fine. The problem is when I add a
>field to the table. How do you properly add the field to the form. The
>only way I have been able to put the field in the block is do a copy and
>then a paste. Then I remain the field to the new field I created and
>make sure the field is set to the proper block. When I try to use the
>form and put data in that field. I receive and unable to insert record
>error. Does anyone know how to add the field without deletnig the block
>and inserting it again.
>
>Thanks in advance.
>
>Antonio
>

To add an existing table field to the form create a text or display item in the Layout Tool and give it the same name as the database table field - for instance, if you added a field called new_field to the table that the block accesses, then add a text or display item and , in the properties list, change the name to new_field and check to be sure that the base table option is True -

This assumes that I understood your question ( Form designed with the existing, at time of design, fields in the table you created - then you add one or more fields to that table and want them to be on the form )

Hope it helps,
John Greco
Oracle DBA Received on Fri May 15 1998 - 18:28:34 CEST