Connecting to a table dynamiclly

Hi,

[Quoted] [Quoted]     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
[Quoted] [Quoted]   set_block_property('REPL_CONS_SITS',QUERY_DATA_SOURCE_NAME, TBL_REPL_SITS);
[Quoted]   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 [Quoted] could this be causing problems?

Thanks

Sean
-----Using Forms 6.0 Received on Mon Aug 21 2000 - 17:55:49 CEST