Re: Can an Oracle Form be Dynamically built/re-arranged at Runtime?

Sure, we did it. Dan is right that you can't create a field at runtime but you can assign it at runtime. We did this in 4.5. We built enough fields to accommodate all circumstances (we have check boxes, pop lists, text fields, ...). The form builds a view on the fly and then connects to it. We use it to support maintenance to all reference tables with 0 development. (It out "cases" Designer).

Probably a better solution to your problem would be to model it generically. Then you wouldn't need to even do anything interesting with your forms.

--
Paul Dorsey
Dulcian, Inc.
www.dulcian.com
212 595 7223
Brit Willoughby wrote in message <35F93867.7AD83FD8_at_lucent.com>...


>

>    We are considering using Oracle Tools (Dev2K, Forms, ect...) to


>create a Web interface to an Oracle database.

>

>    Some of the data has more and different types of properties, than

>other data. This means that if I query the data for

>a part, I may have 25 fields with 25 names, another part may have 15

>fields with 15 different names. I need to create

>a form/page that is dynamically created that will accomodate all

>possible parts without knowing how many properties

>(fields & field names) that part has in advance (the fieldnames are

>queried from a table and a select statement to retreive

>the data is created from that on the fly).

>

>    I currently do it using Java/JDBC and just create the Applet page on

>the fly, but Mr. Boss want's us to use the Oracle

>tools for some reason. Can any of the Oracle tools handle this?

>

>        Brit Willoughby

>        bwilloughby_at_Lucent.com

>

>

>