OraFAQ Forum: Forms » want it urgent.

Home » Developer & Programmer » Forms » want it urgent.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

want it urgent. [message #87443]

Tue, 04 January 2005 23:34

sujjitha
Messages: 1
Registered: January 2005

Junior Member

hi all,

when i press a button i want to move to the next record so fot that i am using the Next_record. here when i reach the last record i want to say that i have reached the last record as a message..

when i reach the first record also the same that i have reached the first record..
how to do that..

thanks for help,,

sujji.

Report message to a moderator

Re: want it urgent. [message #87450 is a reply to message #87443]

Wed, 05 January 2005 12:23

xyz
Messages: 9
Registered: January 2002

Junior Member

you can navigate thru the records using the up and down arrow key.

In the When-new-record-instance trigger, display the message based on system.first_record and system.last_record

Report message to a moderator

Re: want it urgent. [message #87455 is a reply to message #87450]

Wed, 05 January 2005 19:59

Himanshu
Messages: 457
Registered: December 2001

Senior Member

Hi,
Create a trigger ON-Message on the Form level and add following code to it:

If Message_Code = 40100 Then
Message('I: First Record.',NO_ACKNOWLEDGE) ;
ElsIf Message_code = 40352 then
Message('I: Last Record.',NO_ACKNOWLEDGE) ;
End If;

HTH
Regards
Himanshu

Report message to a moderator

Previous Topic:	key-fn
Next Topic:	serial no

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 00:20:39 CST 2025