-
Dynamic IF condition evaluation in Forms Environment
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|