Re: About base table name change at Forms 4.5?

Steve Cosner wrote:
>
> In article <3219027F.1B68_at_cosmos.skec.co.kr>,
> young-bin, park <ybpark-a_at_cosmos.skec.co.kr> wrote:
>
> >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.
>
> You can do it by changing to non-base-table block processing. In
> other words, do all the selecting, locking, updating, etc. in the
> block explicitly using pl/sql code. Of course, this will take about
> 10 times longer to code your form.
>
> Regards,
> Steve CosnerI have experimented with using a synonym for the base table name and
then using a dynamic sql routine to define the synonym at run time. In that way I have been able to change the base table and it seems to work fine.
Good Luck,
Arthur Davis Received on Thu Aug 22 1996 - 00:00:00 CEST