Home » Developer & Programmer » Forms » Error coming
Error coming [message #209976] Mon, 18 December 2006 17:30 Go to next message
smulukutla
Messages: 45
Registered: May 2006
Member
I am getting FRM-40741:Unable to locate record 4 on block u_tmp_funddet. Please let me know what I need to do?

Thanks.
Re: Error coming [message #209995 is a reply to message #209976] Mon, 18 December 2006 20:07 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I assume that you had four records in the block, you saved the record sequence number (from using the get_block_property coomand)into a variable, you deleted a record (or two) from the block and then tried to go back to the record whose number you had saved.

Am I correct?

David
Re: Error coming [message #210144 is a reply to message #209976] Tue, 19 December 2006 10:29 Go to previous messageGo to next message
smulukutla
Messages: 45
Registered: May 2006
Member
Correct, but how do I make sure that this error won't be coming.
Re: Error coming [message #210179 is a reply to message #210144] Tue, 19 December 2006 15:58 Go to previous messageGo to next message
Littlefoot
Messages: 19536
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Don't go to non-existent record.
Re: Error coming [message #210210 is a reply to message #210144] Tue, 19 December 2006 18:59 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
In the When-Remove-Record trigger, if the record being deleted has a row number LESS than the stored number then decrement the stored number. If you get to '0' then set it to '1'. If they delete the record whose number you have saved then you have to decide as to which record to point (previous record or record '1'?).

David
Re: Error coming [message #582640 is a reply to message #210210] Sat, 20 April 2013 11:52 Go to previous messageGo to next message
D_ORA
Messages: 32
Registered: November 2012
Location: UK
Member
HI SIR,
CAN YOU PLEASE EXPLAIN THIS WITH EXAMPLE...
THANKS,
Re: Error coming [message #582641 is a reply to message #582640] Sat, 20 April 2013 12:12 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do NOT post in UPPER case.

Regards
Michel
Re: Error coming [message #582649 is a reply to message #582641] Sat, 20 April 2013 16:38 Go to previous message
Littlefoot
Messages: 19536
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
David explained it - he just didn't write any code, but it shouldn't be too difficult to "translate" his sentences to Oracle statements. Try it! If you don't succeed, come back and post code you managed to write. We'll assist (hopefully, that is).
Previous Topic: Dual monitor forms with alerts/messages --issues
Next Topic: Sending data to POS Customer Display
Goto Forum:
  


Current Time: Mon Sep 01 23:16:33 CDT 2014

Total time taken to generate the page: 0.11395 seconds