StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » How to 'Auto Save' after an edit and scrolling to a new row

How to 'Auto Save' after an edit and scrolling to a new row

Peter Jones — Tue, 20 Mar 2007 10:37:10 GMT

I'm having problems working my way through this issue and I was hoping you could provide a code snippet/advice to show me how I handling this function correctly. I'm using a DevExpress grid and want to auto save any changes as the user moves between rows. To do this I have the following code in the BO:

Private Sub boATT_Navigating(ByVal e As MicroFour.StrataFrame.Business.NavigatingEventArgs) Handles Me.Navigating
   If Me.IsDirty Then
      Me.Save()
   End If
End Sub

This works fine until I add a new record. Then, for some reason, IsDirty is True (when it shouldn't be) and Save executes. The problem is boATT_Navigating keeps getting fired and, because IsDirty is still true, Save executes again and eventually I get a stack overflow on the Save.

I tried (and failed) to find a property that tells me I'm entering 'create a new record' mode. I thought I could add that test to the IsDirty so I don't execute the Save when starting the create new record cycle.

I'm not setting any default values so that isn't the cause if IsDirty being true.

Even though Save is firing no SQL update code is being executed.

Cheers, Peter

RE: How to 'Auto Save' after an edit and scrolling to a new row

Trent L. Taylor — Tue, 20 Mar 2007 10:37:10 GMT

Testing, please ignore :)

RE: How to 'Auto Save' after an edit and scrolling to a new row

Trent L. Taylor — Sun, 04 Mar 2007 21:26:10 GMT

[quote]Then, for some reason, IsDirty is True (when it shouldn't be) and Save executes. [/quote]

This is by design and is correct. IsDirty actually looks to see if there are any records within the CurrentDataTable that have been modified, deleted, or added. So IsDirty is indicating that you have added a record.

I think that you would be better of doing one of two things. Since you are using a grid, and grids are a different animal than any other type of control due to the massive amount of code behind a grid, events may behave slightly different. You should try capturing an event on the grid that indicates that the row has already been navigated...or, try placing your code in the Navigated event rather than the Navigating. This is why your Add behaves the way it does....the navigation to the new row has not yet taken place.