OraFAQ Forum: Forms » FRM-40509

Home » Developer & Programmer » Forms » FRM-40509

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

FRM-40509 [message #78658]

Fri, 08 March 2002 05:44

ceycey
Messages: 22
Registered: February 2002

Junior Member

Hi,
I organized a block to display the results queried from a data table. When I returned to another block after querying, I get the error message FRM - 40509 (it can't update the record in the queried block.)
I don't want to commit the queried form or store the data in the block. How can I prevent that message after querying? (I don' prefer clear_block, because I am displaying some items of the queried block on different canvases.)
Thanks friends.

Report message to a moderator

Re: FRM-40509 [message #78687 is a reply to message #78658]

Mon, 11 March 2002 00:25

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

i think u r changing the value in post-query trigger. either stop doing that or change to control item instead of database item.

Report message to a moderator

Re: FRM-40509 [message #78699 is a reply to message #78687]

Mon, 11 March 2002 08:49

ceycey
Messages: 22
Registered: February 2002

Junior Member

Thanks in advance. That's right, I am changing the value after querying the block. But I have to do that, because I am making some calculations for clear query results.I solved my problem by doing these :
I added a code line that clears the block which displays the query results with no comitting, just before commiting the source block. (CLEAR_BLOCK(NO_COMMIT);)
So when it commited the block, the queried block was cleared.
Thanks in advance. Regards.

Report message to a moderator

Previous Topic:	MDI window problem in forms
Next Topic:	populating list item at runtime ,frm-41337

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 08 14:24:46 CDT 2025