Delete Record Confirmation

[davtech]

When you delete a record from a table a confirmation dialog pops up asking if you want to continue, Yes or No. Is there a way to edit this dialog and/or get the result so that code in a delete button for example can act on this information conditionally? The dialog seems to be a built in Alpha event and I can't find anything on it.

[MikeC]

Re: Delete Record Confirmation

Greg,
As with many Alpha built in functions, they have their own messages and the only possible change that can be made is the Title I believe and then only with the addon Branding Tool.

If you do not want/like an Alpha messagebox in looks, message, or even not wanting it to appear, there is no way I have heard of.

Some functions do have an additional argument that can make it so it won't appear so check that out as well.

What to do is to create your own operation/function that does what you need to do, most times with table methods. Then you can error trap in your own way.


Check out some of the Similar Threads that came up under this one....or do a "delete" search as am sure many will be of use.

[davtech]

Re: Delete Record Confirmation

HI Mike, thanks for replying. I've done some searching but can't seem to find exactly what I'm looking for. I'm not really needing to modify the confirmation dialog that pops up when you delete a record, I just thought that might be useful knowledge in the future if it was possible.

What I really need is to be able to determine if the user selects Yes (go ahead with the delete) or No ( cancel the delete process) from the dialog box. Since this is a built-in Alpha dialog I'm not sure how to get that information. If a user decides to cancel a delete I need to know so that certain things won't happen in the app.

[MikeC]

Re: Delete Record Confirmation

Greg,
I believe you will have to "roll your own" delete script so that your own dialog box comes up---I know of no way to obtain the built in Alpha dialog box choices. That is what you will find in many cases....Alpha makes most things very easy to do, but the trade-off is that you are then somewhat limited if using built-in functionality.

Here is one of MANY delete scripts you could find on the messageboard if you need one. You would simply have your own UI messagebox come up prior to the delete script and then you can trap the choices made from the UI. A general way for the UI messagebox would be the following:

ans = ui_msg_box("Question","Answer yes or no",UI_YES_NO)

if ans = UI_YES_SELECTED
' do this code
else
'do the other code here
end if

This delete script I believe was from a post by Mike Wilson a while back.

dim tbl as P
tbl= table.current()     ' a number goes in the brackets if it's a child record
DIM mode as c
mode = parentform.mode_get()
' Check the mode of the table to assess whether you need the change_begin
   if mode = "ENTER" .or. mode = "CHANGE" then
      tbl.delete()
    
   else if mode = "VIEW" then
    tbl.change_begin()
    tbl.delete()
    tbl.change_end()
   end if

'Refresh data in current form at parent level.
  topparent.Commit()
  topparent.Refresh_Layout()

[davtech]

Re: Delete Record Confirmation

Yeah but how do I stop the Alpha built-in dialog from popping up as well? I can't find anyway to control it. This is really the heart of my issue, if I could just disable it then doing my own dialog would be no big deal and would solve my problem.

[MikeC]

Re: Delete Record Confirmation

When you use the method I illustrated, you are not using Alpha's built-in function which has their messagebox.

[davtech]

Re: Delete Record Confirmation

Oh..... :o I see what you are saying now. I got so tunnel visioned on using the alpha delete script I didn't even think about writing my own. Thanks for your help Mike!