Re: HELP: Forms 4.5 - Multiple tables

schapin_at_my-dejanews.com wrote:
>
> Using Oracle Forms 4.5
>
> We have a multitude of tables which all have the same table definition
> (column names and data types). We would like to have one Oracle Form which
> prompts the user for a table name; and then pulls column information from the
> specified table.
>
> So, the form will perform just like any other form, but the display will refer
> to the user-entered table. All querys, updates will affect the user-entered
> table.
>
> Can it be done? I appreciate any help!
>
> Thank you,
> Steve Chapin
> schapin_at_energygraphics.com
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading

Another possibility is to direct a SYNONYM (or VIEW) to the table you currently intend to use. Set the base table property to the synonym name. When you want to switch over to another table, just recreate the synonym so that it points to the other table.

Form within Forms, you can use the forms_ddl builtin to execute CREATE SYNONYM xxx FOR yyy. You should commit your form before doing so, and I recommend to disconnect and re-connect after forms_ddl, as the cursor related to the base table block is invalid after redirecting the SYNONYM. We have used this technique in a multi-user envirnonment as well, where all users have their private synonym pointing to the needed tables.

Marcus Reichardt
Consultant

Marcus Reichardt Received on Thu Jul 02 1998 - 14:53:04 CEST