OraFAQ Forum: Forms » How to go to First Record in Developer 10g

Home » Developer & Programmer » Forms » How to go to First Record in Developer 10g

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

How to go to First Record in Developer 10g [message #266554]

Tue, 11 September 2007 02:22

dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka

Senior Member

Dear Experts,

I have 4 buttons in the developer 10g forms as:

1. "First Record"
2. "Next Record"
3. "Previous Record"
4. "Last Record"

in the Button 2(When_button_pressed) i have written (Next_record)
it's complied successfully and working properly.

in the Button 3(When_button_pressed) i have written (previous_record)
it's complied successfully and working properly.

in the Button 4(When_button_pressed) i have written (Last_record)
it's complied successfully and working properly.

BUT.
in the Button 1(When_button_pressed) i have written (First_record)
it's not complied successfully and not working at all.

Note: i used the same command(Written in Button-1) in developer 6i it worked successfylly , but not working in developer 10g.

Can any one help me what will be the command to go to the First Record, pls?

Thank you.

Kamal Hossain

Report message to a moderator

Re: How to go to First Record in Developer 10g [message #266657 is a reply to message #266554]

Tue, 11 September 2007 05:44

Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata

Senior Member

Just use the FIRST_RECORD Built-in for go to the first record in your WHEN-BUTTON-PRESSED trigger.

Cheers
Soumen

Report message to a moderator

Re: How to go to First Record in Developer 10g [message #266886 is a reply to message #266657]

Tue, 11 September 2007 22:40

dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka

Senior Member

Dear mr. souman,

I did the same thing FIRST_RECORD under when_button_pressed trigger. and i mention it also in my previous request.

But it does not work in develdoper 10g

but it works in developer 6i.

Other navigation like Previous_record, Last_record,Next_record working in developer 10g but i dont know what happend in FIRST_RECORD.

Thank you.

Kamal Hossain

Report message to a moderator

Re: How to go to First Record in Developer 10g [message #266933 is a reply to message #266886]

Wed, 12 September 2007 01:03

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

Senior Member
Account Moderator

FIRST_RECORD still exists in Oracle Developer Suite 10g so - it just has to work.

Quote:

in the Button 1(When_button_pressed) i have written (First_record)
it's not complied successfully and not working at all.

"Not compiled successfully" isn't very descriptive. Which error did compiler return? Was it ORA-, FRM-, something else?

Report message to a moderator

Previous Topic:	Open LOV after Entering Query Mode
Next Topic:	How to Populate Hierarchical Tree View in runtime

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 04:28:28 CDT 2024