OraFAQ Forum: Forms » HOW TO HANDLE MOUSE CURSOR POSITION IN FORM

Home » Developer & Programmer » Forms » HOW TO HANDLE MOUSE CURSOR POSITION IN FORM

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

HOW TO HANDLE MOUSE CURSOR POSITION IN FORM [message #670341]

Thu, 28 June 2018 05:43

ashag
Messages: 5
Registered: June 2018

Junior Member

I have a Form with multi record.After deleting any record,my cursor position moves to the first record.it doesn't move to the record before the one that is deleted from the record....please help me in this matter Sad

Report message to a moderator

Re: HOW TO HANDLE MOUSE CURSOR POSITION IN FORM [message #670365 is a reply to message #670341]

Thu, 28 June 2018 13:20

Littlefoot
Messages: 21781
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Save record number (:SYSTEM.TRIGGER_RECORD) in KEY-DELREC trigger. After deleting a record, navigate to saved number "minus" 1. Something like this:

declare
  l_rec number := :system.trigger_record;
begin
  delete_record;
  go_record(l_rec - 1);
end;

This is untested; I *hope* it'll be OK. If not, we'll hear about it.

Report message to a moderator

Re: HOW TO HANDLE MOUSE CURSOR POSITION IN FORM [message #670373 is a reply to message #670365]

Thu, 28 June 2018 23:34

ashag
Messages: 5
Registered: June 2018

Junior Member

even after saving record,my cursor position moves to the first record.now in this situation what am i do.......

Report message to a moderator

Re: HOW TO HANDLE MOUSE CURSOR POSITION IN FORM [message #670375 is a reply to message #670373]

Fri, 29 June 2018 03:01

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

Senior Member

Run the form in debug mode and check if there are any triggers/procedures causing the cursor to move.

Report message to a moderator

Previous Topic:	Show a Report on Form Canvas like graph
Next Topic:	need to disable/enable Minimize,Resize and Close button

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 22 14:20:05 CDT 2023