Home » Developer & Programmer » Forms » How to change block_status from 'CHANGED' to 'QUERY'
How to change block_status from 'CHANGED' to 'QUERY' [message #343584] Wed, 27 August 2008 10:26 Go to next message
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:

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.

Re: How to change block_status from 'CHANGED' to 'QUERY' [message #344708 is a reply to message #343584] Mon, 01 September 2008 01:35 Go to previous message
Messages: 10180
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

Previous Topic: Ora-12222 No such Protocol Adapter error
Next Topic: Calling report from report in report 10g
Goto Forum:

Current Time: Tue Aug 22 04:23:33 CDT 2017

Total time taken to generate the page: 0.06958 seconds