Dynamic IF condition evaluation in Forms Environment
I'm using forms 9i. Let's say I have a Block in the form B1. It has two items I1 and I2.
I have a table called T1 that has a column say C1. The data in the only record in T1 is 'NAME_IN(''B1.I1'') = 1 OR NAME_IN(''B1.I2'') = 2'
CREATE TABLE T1 ( C1 VARCHAR2(1000));
INSERT INTO T1 VALUES ('NAME_IN(''B1.I1'') = 1 OR NAME_IN(''B1.I2'') = 2');
In forms I need to execute the following at POST-QUERY trigger of the block:-
IF (VAR1) THEN ==>> This is the problem
Set_Item_Instance_Property( 'B1.I1', CURRENT_RECORD, VISUAL_ATTRIBUTE,'VA1');
As you could see that the IF statement is wrong. But I get the condition (for IF condition) as a string value from some database table. Can anyone tell how to handle this problem.
Thanks & Regards,
Click Here to Expand Forum to Full Width