Error when changing blocks query data source at runtime
Hi In my project 2 datablock is there which is associated with 2view with same column name.Now based on the condition I am changing the QUERY_DATA_SOURCE_NAME but its dispalying error-FRM 41380 Cannot set the block query data source.Can someone suggest how to resolve the issue
Code is written below
V8:=V1||V2||v3||v4||v5||v6||v7;
IF :PROM_CRITERIA.CRITERIA_CATEGORY='ELVS003' THEN
GO_BLOCK('CLARITY_TT');
set_block_property('CLARITY_TT',QUERY_DATA_SOURCE_NAME,'CLARITY_TTELVS003');
set_block_property('CLARITY_TT',default_where,'PROM_NUMBER is not null '||V8);
EXECUTE_QUERY;
Set_Application_Property(Cursor_style,'Normal');
ELSE
GO_BLOCK('CLARITY_TT');
set_block_property('CLARITY_TT',QUERY_DATA_SOURCE_NAME,'CLARITY_TT');
set_block_property('CLARITY_TT',default_where,'PROM_NUMBER is not null '||V8);
EXECUTE_QUERY;
Set_Application_Property(Cursor_style,'Normal');
END IF;