Hi,

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:-

DECLARE
VAR1 VARCHAR2(1000);
BEGIN
SELECT C1
INTO VAR1
FROM T1;

IF (VAR1) THEN ==>> This is the problem
Set_Item_Instance_Property( 'B1.I1', CURRENT_RECORD, VISUAL_ATTRIBUTE,'VA1');
END IF;
END;

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,
Joey