Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Forms 4.5 Questions... Please Help...
Question #1
Try to drop table OLD, and then CREATE SYNONYM OLD FOR NEW See "Server SQL Reference" for details on synonyms. It should work with no need to develop a new form
Question #2
If you have Forms Designer, open your form with the Designer, create a text item or whatever suits your new attribute, place on your form window,
open the properties of the new item, go to the Database set of properties and
map the new item to Base table NEW, column AAA.
Hope this helps.
Rogerio
stephen <c6635500_at_comp.polyu.edu.hk> escreveu no artigo
<342D9D51.2CC6_at_comp.polyu.edu.hk>...
> Hello all,
>
> I have two questions about Forms 4.5.
>
> I want to change the table name from OLD to NEW. After I created the
> table NEW and copy all data to NEW from OLD, should I need to develop a
> new Forms for table NEW? (NEW and OLD have the same data structure) This
> is because the original form is connected with table OLD and not table
> NEW. Is there possible ways so that I don't need to create a new form
> for table NEW?
>
> Moreover, a new attribute AAA is added to the table NEW later. Since
> the Forms does not contain the new attribute AAA, how can I create a
> edit field in Forms and connected this field to the new attriubte AAA in
> table NEW?
>
> Thanks,
> Stephen
>
Received on Sun Sep 28 1997 - 00:00:00 CDT