OraFAQ Forum: Forms » the record is shifted up when check mark checked

Home » Developer & Programmer » Forms » the record is shifted up when check mark checked

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

the record is shifted up when check mark checked [message #187922]

Wed, 16 August 2006 06:29

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

Report message to a moderator

Re: the record is shifted up when check mark checked [message #188136 is a reply to message #187922]

Thu, 17 August 2006 04:20

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:48:56 CDT 2024