| Doubt regarding D2k [message #16420] |
Sat, 27 November 2004 00:23  |
Kasim
Messages: 22
Registered: August 2004
|
Junior Member |
|
|
Hi all,
Sorry to post my doubt in this session. My doubt is regarding to LOV validation in D2k.
I have a Non-database item named - Group Name attached to a LOV. Now I have to validate that field when any invalid value is entered. Believe, we cannot set the Validate from list property to "Yes" for that field, since it is a non-database item . Rather I tried as,
1. Setted the validate from list to "No" for the item - Group name.
2. In POST-QUERY (BLOCK-LEVEL)
IF :SYSTEM.BLOCK_STATUS IN ('NEW','CHANGED') THEN
IF :SYSTEM.RECORD_STATUS IN ('NEW','CHANGED','INSERT') THEN
SET_ITEM_PROPERTY('CMS_T_SYS_GROUP_USER.GROUP_NAME', VALIDATE_FROM_LIST,PROPERTY_TRUE);
ELSE
SET_ITEM_PROPERTY('CMS_T_SYS_GROUP_USER.GROUP_NAME', VALIDATE_FROM_LIST,PROPERTY_FALSE);
END IF;
END IF;
3. In WHEN-NEW-BLOCK-INSTANCE TRIGGER (BLOCK LEVEL)
IF :SYSTEM.BLOCK_STATUS IN ('NEW','CHANGED') THEN
SET_ITEM_PROPERTY('CMS_T_SYS_GROUP_USER.GROUP_NAME', VALIDATE_FROM_LIST,PROPERTY_TRUE);
ELSE
SET_ITEM_PROPERTY('CMS_T_SYS_GROUP_USER.GROUP_NAME', VALIDATE_FROM_LIST,PROPERTY_FALSE);
END IF;
Even after this I couldn't validate the item from LOV. When I enter invalid value the navigation moves to next item without any validation from LOV.
Is there is any other ways to get my problem to be sorted out. Kindly help me out in this regard.
Regards,
Smita
|
|
|
|
|
|
|
|
| Re: Doubt regarding D2k [message #146124 is a reply to message #16420] |
Tue, 08 November 2005 15:50  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
An LOV can be applied to any field, either dfatabase or non-database. Please remove the Post-Query and When-New-Block-Instance triggers as they are at the wrong level. The first fires when a record is retrieved, not when you create a new record (record_status=insert), and the second is when you arrive at the block, not as you are moving betweenrecords in the block.
Just turn the validation on during the build and it should work okay.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
.