OraFAQ Forum: Forms » Block status chages..

Home » Developer & Programmer » Forms » Block status chages..

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

Block status chages.. [message #285909]

Thu, 06 December 2007 01:24

subhash.pophale
Messages: 9
Registered: December 2007
Location: Mumbai

Junior Member

Hi,
Following is my code,
---------------------
If :global.mode in (3) then
go_block('acc_poa_mapping');
message(:system.block_status); pause; --msg1
If :system.block_status = 'NEW' Then
clear_block;
Execute_query(no_validate);
message(:system.block_status); pause; --msg2
end if;
---------------------------------
Here msg1 is 'NEW' and msg2 is 'Changed' instead of 'Query' and this is giving me problem...pla suggest on this why it is 'Changed' instead of 'query'.

Report message to a moderator

Re: Block status chages.. [message #285923 is a reply to message #285909]

Thu, 06 December 2007 01:55

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Dear a block's status is changed because of only one action and that is manupulation.

Check if any item is updated during this process automaticlly by any of procedure, function or trigger.

If you are using non-base table items in your base table block then plz also check the property of base table = No.

Regards,
Azam Khan

Report message to a moderator

Re: Block status chages.. [message #285958 is a reply to message #285909]

Thu, 06 December 2007 03:24

subhash.pophale
Messages: 9
Registered: December 2007
Location: Mumbai

Junior Member

thanks Khan.
I checked my triggers and there was one post-query trigger in which i was populating the value of one item

Report message to a moderator

Previous Topic:	database message retrive from forms
Next Topic:	ora-01422

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 00:51:49 CST 2025