Home » Developer & Programmer » Forms » FRM-40509
FRM-40509 [message #78658] Fri, 08 March 2002 05:44 Go to next message
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.
Re: FRM-40509 [message #78687 is a reply to message #78658] Mon, 11 March 2002 00:25 Go to previous messageGo to next message
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.
Re: FRM-40509 [message #78699 is a reply to message #78687] Mon, 11 March 2002 08:49 Go to previous message
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.
Previous Topic: MDI window problem in forms
Next Topic: populating list item at runtime ,frm-41337
Goto Forum:
  


Current Time: Fri Mar 29 03:21:57 CDT 2024