OraFAQ Forum: Forms » How to change block_status from 'CHANGED' to 'QUERY'

Home » Developer & Programmer » Forms » How to change block_status from 'CHANGED' to 'QUERY'

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

How to change block_status from 'CHANGED' to 'QUERY' [message #343584]

Wed, 27 August 2008 10:26

ommin
Messages: 22
Registered: June 2006
Location: pune,India

Junior Member

Hi Champs,

I have a query only form, on which data query only allowed.
but on post-query trigger some of the text-items gets populated by select stmt.
Because of this the block_status of the block get changed as 'QUERY' to 'CHANGED'. On post-query trigger i'm setting the record-status on each record in QUERY as below:
set_record_property(:system.cursor_record,'equ_11',STATUS,QUERY_STATUS);

but after this also the block status remain as 'CHANGED'.
i want to change the block_status from 'CHANGED' to 'QUERY'.

how to do it.

Thanks
Omi.

Report message to a moderator

Re: How to change block_status from 'CHANGED' to 'QUERY' [message #344708 is a reply to message #343584]

Mon, 01 September 2008 01:35

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

Senior Member
Account Moderator

did you consider searching this forum for 'changed query'? IF you had, you would have found http://www.orafaq.com/forum/m/327201/67467/?srch=changed+query#msg_327201

David

Report message to a moderator

Previous Topic:	Mouse Triggers in 10g
Next Topic:	Disable the main menu in Oracle Form 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 12:50:57 CST 2025