Home » Developer & Programmer » Forms » the record is shifted up when check mark checked
the record is shifted up when check mark checked [message #187922] Wed, 16 August 2006 06:29 Go to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member


Hii All

I have a problem in my form
as my form contain a check mark "check" that when click on it there is a summation performed to "vsum"

i used :=:SYSTEM.CURSOR_RECORD to store the record that i check on it
so that i can return to it after check

there problem is that when i check it return to same record
but that record is shifted up and the mouse now is on another record and the scroll move down


here is the code
DECLARE
	vSUM NUMBER :=0;
	vCURRECORD NUMBER;
BEGIN

vCURRECORD :=:SYSTEM.CURSOR_RECORD;
  GO_BLOCK ('GBILLPAXX');
  FIRST_RECORD;
  LOOP 
		  IF (:CHECK  = 'Y') THEN
		    vSUM :=vSUM + :VALUE;
  	
		  END IF;
  EXIT WHEN (:SYSTEM.LAST_RECORD = 'TRUE');
  NEXT_RECORD;
  END LOOP;

GO_RECORD (vCURRECORD);



how can i solve this

Thanks for everyone Helped and helping me
Re: the record is shifted up when check mark checked [message #188136 is a reply to message #187922] Thu, 17 August 2006 04:20 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at http://www.orafaq.com/forum/m/133154/67467/?srch=top_record#msg_133154 if you use a combination of top_record and records_displayed you can overcome your problem.

David
Previous Topic: Master \ Detail: copy value from another block
Next Topic: Problem in a Formula item
Goto Forum:
  


Current Time: Sun Dec 11 08:01:45 CST 2016

Total time taken to generate the page: 0.11160 seconds