Re: base table in runform
From: Steven P. Muench <smuench_at_doh.us.oracle.com>
Date: Sun, 7 Nov 1993 06:02:20 GMT
Message-ID: <SMUENCH.93Nov6220220_at_doh.us.oracle.com>
Product Manager Received on Sun Nov 07 1993 - 07:02:20 CET
Date: Sun, 7 Nov 1993 06:02:20 GMT
Message-ID: <SMUENCH.93Nov6220220_at_doh.us.oracle.com>
HA KONG -- There is no way to dynamically change the base table for a
block. Some people have achieved similar functionality by basing their block on a synonym and basing their block on the synonym whose definition they change dynamically at runtime by calling SQL*PLUS. In Forms 4.0 we have the concept of record groups that are in-memory tables which can be populated by arbitrary SELECT statements, and transactional triggers which would let you populate your block from one of the record groups. Forms 4.1 will bring the concept of record groups and blocks even further into sync. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Steve Muench Email: smuench_at_oracle.comForms Development
Product Manager Received on Sun Nov 07 1993 - 07:02:20 CET