Home » Developer & Programmer » Forms » FRM-40352 and Last record of query (Oracle Form)
FRM-40352 and Last record of query [message #344351] Fri, 29 August 2008 08:47 Go to next message
mhakimjavadi
Messages: 37
Registered: July 2008
Member
Hello Everybody

I have a problem with Oracle Forms and I don't know how to resolve it.

Could everyone help me?

The problem appears when I try to navigate the last record of a block using the scrollbar, Keyboard or Mouse.

Then the error FRM-40352 appears.

How can I control that? I would like to control that, when the user try to go next record after the last record the control back to first record.

Thank a lot

Report message to a moderator

Re: FRM-40352 and Last record of query [message #344441 is a reply to message #344351] Fri, 29 August 2008 16:17 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use the ON-ERROR trigger; something like
if err_type = 'FRM' and err_code = 40352 then
  do_something_here;
end if;

Report message to a moderator

Re: FRM-40352 and Last record of query [message #344478 is a reply to message #344351] Sat, 30 August 2008 00:05 Go to previous messageGo to next message
sasipalarivattom
Messages: 121
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member
Hi dear,

This is FRM-40352 error Description.

FRM-40352: Last record of query retrieved.

Cause: You pressed [Down], [Next Record], [Next Set of Records], or [Scroll Down] after all records had been retrieved.

Action: No action is necessary.

Level: 5

Type: Informative


Note that this is an Informative message and not an error.
So no action is required. However you can use the code given by littlefoot to avoid the showing this message.

Regards Sasi...

Report message to a moderator

Re: FRM-40352 and Last record of query [message #344915 is a reply to message #344478] Mon, 01 September 2008 20:54 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Alternatively, in the 'down' trigger, test whether you are on the 'last record' and if so DON'T go down.

Look at http://www.orafaq.com/forum/m/317726/67467/?srch=system+last_record+down#msg_317726

David

Report message to a moderator

Previous Topic: date display through global varibales
Next Topic: Ora-12222 No such Protocol Adapter error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 09 08:14:04 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.