Home » Developer & Programmer » Forms » HOW TO HANDLE MOUSE CURSOR POSITION IN FORM
HOW TO HANDLE MOUSE CURSOR POSITION IN FORM [message #670341] Thu, 28 June 2018 05:43 Go to next message
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
Re: HOW TO HANDLE MOUSE CURSOR POSITION IN FORM [message #670365 is a reply to message #670341] Thu, 28 June 2018 13:20 Go to previous messageGo to next message
Littlefoot
Messages: 21564
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.
Re: HOW TO HANDLE MOUSE CURSOR POSITION IN FORM [message #670373 is a reply to message #670365] Thu, 28 June 2018 23:34 Go to previous messageGo to next message
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.......
Re: HOW TO HANDLE MOUSE CURSOR POSITION IN FORM [message #670375 is a reply to message #670373] Fri, 29 June 2018 03:01 Go to previous message
cookiemonster
Messages: 13894
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.
Previous Topic: Show a Report on Form Canvas like graph
Next Topic: need to disable/enable Minimize,Resize and Close button
Goto Forum:
  


Current Time: Sun Jun 07 02:19:22 CDT 2020