Re: Connecting to a table dynamiclly
From: Sean <s_at_hotmail.com>
Date: Tue, 22 Aug 2000 10:57:25 -0400
Message-ID: <39A294D5.858EDD5B_at_hotmail.com>
> > 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
Date: Tue, 22 Aug 2000 10:57:25 -0400
Message-ID: <39A294D5.858EDD5B_at_hotmail.com>
[Quoted] No it is supposed to be two underscores, I don't know why they made it like
[Quoted] [Quoted] that...I'll check out the length of the table names maybe that is it? It is
really weird
[Quoted] [Quoted] because the same code works with one thing changed in a different module in the
app...
Thanks
Sean
[Quoted] "Matt B." wrote:
> "Sean" <s_at_hotmail.com> wrote in message news:39A15105.B07ECF4E_at_hotmail.com...> > following code to
> > Hi,
> > I am having problems retrieving fromn a dynamic table. I have the
> > 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
> > Two questions (w/o having developer in front of mem - I'll hafto try some more [Quoted] > from work tomorrow morning): > [Quoted] > 1. Aren't table names limited to 30 characters? (Not sure - I'll hafto check [Quoted] > tomorrow on this at work.) Could your varchar2(50) be a problem? > [Quoted] > 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? > > -MattReceived on Tue Aug 22 2000 - 16:57:25 CEST