Home » Developer & Programmer » Forms » Can't browse previous records / form query F8 is not working
Can't browse previous records / form query F8 is not working [message #392420] Tue, 17 March 2009 23:06 Go to next message
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 Go to previous messageGo to next message
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.
Re: Can't browse previous records [message #392520 is a reply to message #392420] Wed, 18 March 2009 04:48 Go to previous messageGo to next message
cookiemonster
Messages: 12409
Registered: September 2008
Location: Rainy Manchester
Senior Member
Are you starting with a blank record when you press F8?
Re: Can't browse previous records [message #392527 is a reply to message #392420] Wed, 18 March 2009 05:07 Go to previous messageGo to next message
leumas
Messages: 22
Registered: March 2009
Location: philippines
Junior Member
No. I have several records in my database.
Re: Can't browse previous records [message #392530 is a reply to message #392420] Wed, 18 March 2009 05:19 Go to previous messageGo to next message
cookiemonster
Messages: 12409
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?
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 Go to previous messageGo to next message
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.
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 Go to previous message
cookiemonster
Messages: 12409
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.
Previous Topic: Query
Next Topic: Cursors and Set_Block_Property
Goto Forum:
  


Current Time: Tue Dec 06 12:28:32 CST 2016

Total time taken to generate the page: 0.10937 seconds