Home » Developer & Programmer » Forms » Block status chages..
Block status chages.. [message #285909] Thu, 06 December 2007 01:24 Go to next message
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'.
Re: Block status chages.. [message #285923 is a reply to message #285909] Thu, 06 December 2007 01:55 Go to previous messageGo to next message
azamkhan
Messages: 548
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
Re: Block status chages.. [message #285958 is a reply to message #285909] Thu, 06 December 2007 03:24 Go to previous message
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
Previous Topic: database message retrive from forms
Next Topic: ora-01422
Goto Forum:
  


Current Time: Sat Dec 10 05:18:36 CST 2016

Total time taken to generate the page: 0.23022 seconds