OraFAQ Forum: Forms » how to stop going to next record if it is the last record?

Home » Developer & Programmer » Forms » how to stop going to next record if it is the last record? (Oracle 10g)

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

how to stop going to next record if it is the last record? [message #541454]

Tue, 31 January 2012 08:03

baliberde
Messages: 201
Registered: January 2012
Location: outer space

Senior Member

Hi, i want to know how to stop going to next record if it finds the last record. Because when i click my next button(it is the last record), i try to click my previous or first button but it won't go back, enter-query mode is the error message. pls help

Report message to a moderator

Re: how to stop going to next record if it is the last record? [message #541458 is a reply to message #541454]

Tue, 31 January 2012 08:15

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

Senior Member

What's the full error message?

Report message to a moderator

Re: how to stop going to next record if it is the last record? [message #541463 is a reply to message #541458]

Tue, 31 January 2012 08:39

baliberde
Messages: 201
Registered: January 2012
Location: outer space

Senior Member

another error message i got is frm-40102: record must be entered or deleted first

Report message to a moderator

Re: how to stop going to next record if it is the last record? [message #541466 is a reply to message #541463]

Tue, 31 January 2012 09:27

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

Senior Member

What's the full error message that mentions enter query?

Report message to a moderator

Re: how to stop going to next record if it is the last record? [message #541475 is a reply to message #541454]

Tue, 31 January 2012 10:14

baliberde
Messages: 201
Registered: January 2012
Location: outer space

Senior Member

"frm-41009-Function Key not allowed, press cntrl + F1 for the list of valid key's"

Report message to a moderator

Re: how to stop going to next record if it is the last record? [message #541476 is a reply to message #541475]

Tue, 31 January 2012 10:17

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

Senior Member

?
I don't see enter-query mentioned?
So why did you mention it in the first post?

Report message to a moderator

Re: how to stop going to next record if it is the last record? [message #541480 is a reply to message #541476]

Tue, 31 January 2012 11:04

baliberde
Messages: 201
Registered: January 2012
Location: outer space

Senior Member

Cannot navigate out of current block in enter-query mode.

Report message to a moderator

Re: how to stop going to next record if it is the last record? [message #541481 is a reply to message #541480]

Tue, 31 January 2012 11:09

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

Senior Member

And that error is correct. You can't navigate out of the current block in enter-query mode by design.
So why are you trying to?

Report message to a moderator

Re: how to stop going to next record if it is the last record? [message #541487 is a reply to message #541481]

Tue, 31 January 2012 12:20

baliberde
Messages: 201
Registered: January 2012
Location: outer space

Senior Member

If i navigate through my records and reach the last one, it should stop there and shouldn't go to a blank field

Report message to a moderator

Re: how to stop going to next record if it is the last record? [message #541490 is a reply to message #541487]

Tue, 31 January 2012 12:39

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

Senior Member

And what's this got to do with enter-query mode?
You can add key-next-rec and key-down triggers that check :system.last_record and do null if it's true, otherwise next_record.

Report message to a moderator

Previous Topic:	Draw diagram in oracle form.
Next Topic:	New Visual in Oracle Forms (Master / Detail)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 22:28:33 CST 2025