I attempting to update the current row after a save (to get the values of some calculated columns from SQL Server). I have a method that uses AppendDataTable to update a single row. When this is called, the BO is dirtied and then I get a "do you want to save changes" message. From the user's perspective, what they see is:



- they save the record by clicking on "Save"

- Then they are asked if they want to save changes (duh, like, of course I do...I just clicked "Save"!)



Now, if they click Yes or No, it makes no difference, as the changes are fresh from the DB in any case. Cancel makes no sense as I'm doing this in AfterSave and the form has already put the BO into idle state.



So, what am I doing wrong here/how can I deal with this?

Yeah, I tried that. I tried to call it right after calling AppendDataTable(). Unfortunately, the message already occurred. I.e. the bo is dirtied by the AppendDataTable call (apparently), and user is prompted to save changes before it returns.

Greg,

You might want to try an ImportRow or LoadDataRow since you have a record from a DataTable that you are trying to import.  You can specify whether or not to preserve the row state (which is sounds like in this case you wouldn't want to.  It may look something like this:

LoadDataRow:

ImportRow: