OraFAQ Forum: Forms » Can't browse previous records / form query F8 is not working

Home » Developer & Programmer » Forms » Can't browse previous records / form query F8 is not working

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

Can't browse previous records / form query F8 is not working [message #392420]

Tue, 17 March 2009 23:06

leumas
Messages: 22
Registered: March 2009
Location: philippines

Junior Member

I can't seem to browse through previous records using the F8 function. The form asks me to fill every required field.

[MERGED by LF]

[Updated on: Wed, 18 March 2009 05:43] by Moderator

Report message to a moderator

form query F8 not working [message #392488 is a reply to message #392420]

Wed, 18 March 2009 03:31

leumas
Messages: 22
Registered: March 2009
Location: philippines

Junior Member

Hi! I would like to ask for anyone's help. I can't execute a query in my form. whenever i execute a query oracle moves the cursor to a required field and asks me to input a value.

Report message to a moderator

Re: Can't browse previous records [message #392520 is a reply to message #392420]

Wed, 18 March 2009 04:48

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

Senior Member

Are you starting with a blank record when you press F8?

Report message to a moderator

Re: Can't browse previous records [message #392527 is a reply to message #392420]

Wed, 18 March 2009 05:07

leumas
Messages: 22
Registered: March 2009
Location: philippines

Junior Member

No. I have several records in my database.

Report message to a moderator

Re: Can't browse previous records [message #392530 is a reply to message #392420]

Wed, 18 March 2009 05:19

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

Senior Member

I assumed you had records in the database otherwise you wouldn't be trying to query them. That's not what I asked.

Is the record in the form that the cursor is in when you press F8 blank?

Report message to a moderator

Re: Can't browse previous records / form query F8 is not working [message #392675 is a reply to message #392420]

Wed, 18 March 2009 19:23

leumas
Messages: 22
Registered: March 2009
Location: philippines

Junior Member

Oh. sorry. I don't have a cursor. I was told that the query in oracle does the fetching from the database. I found what was wrong this line of code ":requisitions.bran_branch_code := Get_Usr_Tmpbrch(:parameter.cgu$user,trunc(sysdate));" was affecting the forms.

Report message to a moderator

Re: Can't browse previous records / form query F8 is not working [message #392806 is a reply to message #392420]

Thu, 19 March 2009 05:45

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

Senior Member

While cursor in oracle usually means

CURSOR <blah> IS 
SELECT....

A cursor in a record in oracle forms would be the other type of cursor:

Computers. a movable, sometimes blinking, symbol that indicates the position on a CRT or other type of display where the next character entered from the keyboard will appear, or where user action is needed, as in the correction of an erroneous character already displayed.

Never mind.
Glad you sorted your problem.

Report message to a moderator

Previous Topic:	Query
Next Topic:	Cursors and Set_Block_Property

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:32:06 CDT 2024