OraFAQ Forum: Forms » VALIDATION STATUS OF ITEM AND RECORD

Home » Developer & Programmer » Forms » VALIDATION STATUS OF ITEM AND RECORD

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

VALIDATION STATUS OF ITEM AND RECORD [message #177371]

Wed, 14 June 2006 06:37

indraneelkumar
Messages: 24
Registered: September 2005
Location: bangalore

Junior Member

Hi,
I read that the validation status of record is defferent from :SYSTEM.RECORD_STATUS. In a data block one non database item is there,and that is populated with post-query.There is a WHEN-VALIDATE-RECORD TRIGGER at block level. First i will query the datablock and i will change value in non database item. Now if i find the :SYSTEM.RECORD_STATUS it gives "QUERY". If i move to next So :SYSTEM.RECORD_STATUS and record validation status are different. How to find the validation status record and item.

Thanks in advance,
INDRANEEL.

[mod-edit]removed caps lock

[Updated on: Wed, 14 June 2006 06:55] by Moderator

Report message to a moderator

Re: VALIDATION STATUS OF ITEM AND RECORD [message #177671 is a reply to message #177371]

Fri, 16 June 2006 01:18

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Look at Get_Record_Property and Get_Block_Property.

David

Report message to a moderator

Re: VALIDATION STATUS OF ITEM AND RECORD [message #177719 is a reply to message #177671]

Fri, 16 June 2006 04:10

indraneelkumar
Messages: 24
Registered: September 2005
Location: bangalore

Junior Member

Hi David
Thanks for reply.

But I think STATUS is different for VALIDATION STATUS.
Once again I wil tell you what am asking.

I have a Data Base block. In that block one contol item is there. In block level WHEN_VALIDATE_RECORD trigger is there.
That control item is populated with POST-QUERY trigger.

First of all I will Query the Data Block, then status of the record is "QUERY". I will change the value in control item,
then also status of the record is "QUERY".
But if I go the next record then WHEN_VALIDATE_RECORD is firing.
That means STATUS and VALIDATION STATUS of the record different.

Now what am asking is how to find that VALIDATION STATUS of that record.

Thanks in advance,
Indraneel.

Report message to a moderator

Re: VALIDATION STATUS OF ITEM AND RECORD [message #177972 is a reply to message #177719]

Sun, 18 June 2006 20:33

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you tried displaying the various status codes?

The following code will have to be expanded

message('rec stat='||get_record_property(xxx,status)); pause;
message('blk stat='||get_record_property(xxx,status)); pause;

Put this code into your When-Validate-Item and When-Validte-Record triggers and see what is happening.

By the way you HAVE defined your control item as being non-database haven't you?

David

Report message to a moderator

Previous Topic:	calender in ORACLE FORM
Next Topic:	message line parameters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 12:41:00 CST 2025