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.

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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.

Report message to a moderator

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: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Don't go to non-existent record.

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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,

Report message to a moderator

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: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Do NOT post in UPPER case.

Regards
Michel

Report message to a moderator

Re: Error coming [message #582649 is a reply to message #582641] Sat, 20 April 2013 16:38 Go to previous message
Littlefoot
Messages: 21823
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).

Report message to a moderator

Previous Topic: Dual monitor forms with alerts/messages --issues
Next Topic: Sending data to POS Customer Display
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 02 20:05:17 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.