I have something strange happening and I'm not quite sure why. I have 2 datawindows dw_master, dw_child. When a user clicks on a new row in the master I have code in the rowfucuschanging of dw_master that will prompt user to save changes if there are any. The messagebox options are yes, no, cancel.
When I press cancel, I'm prompted again to save my changes, I press cancel again and this time I'm returned to the window. Why would the rowfocuschanging be fired twice??
NOTE: This is a pfc datawindow, so I'm not sure if that has anything to do with it. The master detail is not setup. Do I have to set up the master/detail relationship to get rowfocuschanging to work.
Here is the code that was added to the rowfocuschanging
IF dw_acct_code.ModifiedCount() > 0 OR dw_acct_code.DeletedCount() > 0 THEN
//Case: Changes are pending in the Account Code dw
li_rtnval = gnv_app.Message("APPL_ABS_LD_SAVE_ACCOUNT_CODES")
CHOOSE CASE li_rtnval
CASE 1 //user chose ok
//save the changes, if save fails prevent the rowfocus from changing
IF wf_save() <> 1 THEN RETURN 1
CASE 3 //user chose cancel
//prevent the row from changing