Re: Connecting to a table dynamiclly

From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: Mon, 21 Aug 2000 19:08:12 -0700
Message-ID: <sq3nsvdqt9143_at_corp.supernews.com>

"Sean" <s_at_hotmail.com> wrote in message news:39A15105.B07ECF4E_at_hotmail.com...
> Hi,
> I am having problems retrieving fromn a dynamic table. I have the
> following code to
> set what table is to be queried.
>
> DECLARE
> TBL_REPL_SITS varchar2(50) :=
> 'SVW__'||:GLOBAL.ENVCHG||'_NTL_REPL_CONS_SITS';
> BEGIN
> set_block_property('REPL_CONS_SITS',QUERY_DATA_SOURCE_NAME,
> TBL_REPL_SITS);
> set_block_property('REPL_CONS_SITS', default_where,'process_type =
> 1');
> EXECUTE_QUERY;
> END;
>
> For some reason this will not work for this form? I have done it this
> way in another form in the same app but it will not set the table
> name... does anyone have any ideas?
>
> I also have another block in the module that is used as a control block
> could this be causing problems?
>
> Thanks
>
> Sean
> -----Using Forms 6.0

[Quoted] Two questions (w/o having developer in front of mem - I'll hafto try some more from work tomorrow morning):

1. Aren't table names limited to 30 characters? (Not sure - I'll hafto check tomorrow on this at work.) Could your varchar2(50) be a problem?
2. In your declare/assignment statement: 'SVW__'||:GLOBAL.ENVCHG||'_NTL_REPL_CONS_SITS';

You have two underscores after the "SVW". Is that a typo? Should it only be [Quoted] one underscore?

-Matt Received on Tue Aug 22 2000 - 04:08:12 CEST