Re: Connecting to a table dynamiclly

I think so. I have a message box pop up when it loads and it is displaying the correct
value? Is there a better way to check?

Thanks

Sean

Mike Dwyer wrote:

> 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 - 17:06:38 CEST