lov error [message #380313] |
Sat, 10 January 2009 09:52 |
laith
Messages: 41 Registered: December 2008 Location: U.A.E
|
Member |
|
|
I have 2 blocks, first one has text item (term_code) and this one has LOV giving me (200910,200830,200820,200810) and i want to write code in first block(KEY_NXTBLK) so if i chose the max of those number(from lov)..i can do what ever in the next block, but if i chose the others ... i can not do anything ( just query).
i write this code but it's giving me error and i dont think is right one ?? help please .
IF :TERM_CODE = select max (fytrtrm_term_code) from fytrtrm
THEN
SET_BLOCK_PROPERTY('FYTRCAT',INSERT_ALLOWED,PROPERTY_FALSE);
SET_BLOCK_PROPERTY('FYTRCAT',UPDATEABLE ,PROPERTY_FALSE);
ELSE
SET_BLOCK_PROPERTY('FYTRCAT',INSERT_ALLOWED,PROPERTY_TRUE);
SET_BLOCK_PROPERTY('FYTRCAT',UPDATEABLE ,PROPERTY_TRUE);
END IF;
|
|
|
|
|