Re: About base table name change at Forms 4.5?
Date: 1996/08/21
Message-ID: <VHAUSWUR.57.321ACF5A_at_Materna.DE>#1/1
In article <3219027F.1B68_at_cosmos.skec.co.kr> "young-bin, park" <ybpark-a_at_cosmos.skec.co.kr> writes:
>From: "young-bin, park" <ybpark-a_at_cosmos.skec.co.kr>
>Subject: About base table name change at Forms 4.5?
>Date: Tue, 20 Aug 1996 09:10:39 +0900
>Hi, all.
>I'm developing Project Progress Manag't System with Forms 4.5.
>While I was working on it. I found one problem. I need to change
>Base table name at runtime when the tables that have same data
>structure at Block of Forms 4.5.
>Does anybody have solution for it?
>Any answer will be highly appreciated.
>
> Park
>Email : ybpark-a_at_cosmos.skec.co.kr
We use a union-view and we have a function which tells the view which part of the view is to be read.
CREATE VIEW viw_abc
AS SELECT
( .. )attr_a,
( .. )attr_b
FROM
(select 1 dummy from dual where pkg_ctrl.fnc_what_part = 'PART1'),
tbl_a,
tbl_b,
tbl_c
WHERE
....
UNION ALL SELECT
( .. )attr_a,
( .. )attr_b
FROM
(select 1 dummy from dual where pkg_ctrl.fnc_what_part = 'PART2'),
tbl_a, tbl_b, tbl_c
Before reading the view you call a procedure which sets a variable in the pkg_ctrl to 'PART1' or 'PART2'.
The problem using a UNION-view is of course that you can't use FORMS default
processing for insert, update, delete.
Regards
Volker
Received on Wed Aug 21 1996 - 00:00:00 CEST