OraFAQ Forum: Forms » CURRENT RECORD

Home » Developer & Programmer » Forms » CURRENT RECORD (forms6i)

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

CURRENT RECORD [message #514351]

Mon, 04 July 2011 04:13

rajendaroracle
Messages: 80
Registered: May 2011
Location: India

Member

Hi,

how to focus on current record in oracle forms.

for ex:- I have 10 records in line level.i want to focus my cursor on perticular like (5th record) how to possible in form.

Is there any built-in like current_record?

Report message to a moderator

Re: CURRENT RECORD [message #514353 is a reply to message #514351]

Mon, 04 July 2011 04:24

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

The current record is the record the cursor is in - :system.cursor_record will get you the number.
What exactly do you mean by "focus on current record"?

Report message to a moderator

Re: CURRENT RECORD [message #514355 is a reply to message #514351]

Mon, 04 July 2011 04:25

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You don't have to focus to the current record, because - the focus already is on the current record.

If you want to go to a certain record in a block, you'd use GO_RECORD built-in.

Report message to a moderator

Re: CURRENT RECORD [message #514361 is a reply to message #514353]

Mon, 04 July 2011 04:57

rajendaroracle
Messages: 80
Registered: May 2011
Location: India

Member

Thanks for your reply,
I have 1000 lines in the form but one time it is showing 8 lines in the form. Now i will check the check box for some lines 5,10,20,35 like this. after that i will press push button it will generate req numbers for that lines that time cursor should be on 35 record.that is last record.

Report message to a moderator

Re: CURRENT RECORD [message #514365 is a reply to message #514361]

Mon, 04 July 2011 05:14

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Use go_record.

Report message to a moderator

Previous Topic:	trigger of form
Next Topic:	Autofill Block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 21:22:21 CDT 2024