Cancel New Record Event

[aschone]

When you start creating a new record and then press "ESC" prior to saving of the record, Alpha5 will present a prompt asking "Are you sure you want to lose your changes". I would like to change the value of a variable if the user clicks yes. If no is click I want to do nothing.

I am assuming that there is an event that I can use to execute my code, but am at a lose as to what event it is or how to determine what events are firing during that time.

[Tom Cone Jr]

Re: Cancel New Record Event

Andrew, I think this is going to be difficult.

I'd try to use the OnKey event for your form to trap the ESC key and prevent it from canceling the ENTER. Instead, I'd popup a message box asking the user to confirm that they want to cancel, and depending upon their answer I'd do the processing you need and then let the script cancel the pending new record, or if they don't want to cancel do nothing.

Later:

if a_user.key.value = "{ESC}"
	a_user.key.handled = .T.
	IF a_user.key.event = "down" 
    	if parentform.mode_get() = "ENTER"

       	 	result = ui_msg_box("Cancel?","Cancel pending new record ?",UI_YES_NO)
        	if result = ui_yes_selected then
                     '[COLOR="Red"]do your processing here, then[/COLOR]
             	     parentform.cancel()
                else
            	     msgbox("","User selected no.  So return to editing.")
            	                 
        	end if

    	end if 
    end if

end if

[aschone]

Re: Cancel New Record Event

Tom-

Thank you for the help. I had thought about doing a key capture and then forcing my code to run, but that will only solve the problem if the user cancels via the "ESC" key.

I believe that if the user where to close the form prior to saving the record that I will need to execute my code at that point as well.

Is there any other way, that i am not thinking of, that a user can cancel a new record prior to saving it?


-Andy

[Tom Cone Jr]

Re: Cancel New Record Event

Users are endlessly creative.

I think you're going to have to experiment with the menu and tool bar buttons displayed on your form to see what they might choose.

Unless there's something on the tool bar or in your menu that will do a cancel I should think that trapping the ESC key, and then trapping the form's CanExit event would just about cover it.

[MoGrace]

Re: Cancel New Record Event

Tom couldn't he use the OnKey to trap the ESC key so it does nothing and that way force the user to employ a button on the form to Cancel instead? Then he could run his script from the button.

[Tom Cone Jr]

Re: Cancel New Record Event

Hello, Robin.

I don't understand your question since I've recommended using the OnKey event to trap the ESC key in earlier posts in this thread. -- tom

[MoGrace]

Re: Cancel New Record Event

Tom,
You suggested putting his code in the OnKey script. I was thinking, couldn't he just stop the normal action of the ESC key there and put his script in a button instead? What would the OnKey script be to do only that?

[Tom Cone Jr]

Re: Cancel New Record Event

'Date Created: 16-May-2007 11:32:24 AM
'Last Updated: 16-May-2007 11:32:24 AM
'Created By  : Tom
'Updated By  : Tom
if a_user.key.value = "{ESC}"
	a_user.key.handled = .T.
end if

This will trap the ESC key regardless of the form's mode. Yes, you could put a button on the form to cancel pending edits, but it should check the mode before canceling. If the mode is VIEW you don't want to CANCEL, if you see what I mean.

[MoGrace]

Re: Cancel New Record Event

Thanks Tom, I always do "something" in my OnKey scripts and had not tried just throwing the key away and was not sure how to do that. Its always the simple things that get convulted... (in MY mind, ie!)