Re: Connecting to a table dynamiclly

[Quoted] Have you verified that the global variable has been set properly when this code executes?

"Sean" <s_at_hotmail.com> wrote in message news:39A294D5.858EDD5B_at_hotmail.com...
> No it is supposed to be two underscores, I don't know why they made it
 like
> that...I'll check out the length of the table names maybe that is it? It
 is
> really weird
> because the same code works with one thing changed in a different module
 in the
> app...
>
> Thanks
>
> Sean
>
> "Matt B." wrote:
>
> > "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
> >
> > 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
> > one underscore?
> >
> > -Matt
>
Received on Wed Aug 23 2000 - 16:53:12 CEST