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
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: 20891
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;
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: 118
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...
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: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: date display through global varibales
Next Topic: Ora-12222 No such Protocol Adapter error
Goto Forum:
  


Current Time: Sat Dec 03 20:14:36 CST 2016

Total time taken to generate the page: 0.18606 seconds