Original Field Value

StrataFrame Forum

Back

Original Field Value

Author	Message
Tim Dol	Tim Dol posted 18 Years Ago Topic Details Share Topic
Group: Forum Members Posts: 340, Visits: 1.4K	I need to compare the current value of a field with the original value. Where can I find the original value within the BO. Thanks Tim
	Reply Like 0
Replies
Tim Dol	Tim Dol posted 18 Years Ago Post Details Share Post
Group: Forum Members Posts: 340, Visits: 1.4K	Actually I have been looking at this on a row by row basis, when I really should be looking at this from the currentdatatable perspective, so I guess I will need to loop through the BO and check values for any rows that have changed. Any suggestions on how/where I should be adding the compare logic, (BeforeSave, AfterSave?) to implement this type of logic and how I get access to original values. Basically I need to execute routines when specific fields have been changed. Example: Automatically create a note on the customer's account when the user changes the credit limit. Any help is appreciated. Thanks Tim
	Reply Like 0
Greg McGuffey	Greg McGuffey posted 18 Years Ago Post Details Share Post
Group: Forum Members Posts: 2K, Visits: 6.6K	To find the original values versus the new values (current values) use something like this: '-- Get the current value of the current row ' Note the use of the FieldNames enum (created for each BO) Dim currValue As String = MyBo.CurrentRow.Item(MyBoFieldNames.MyField,DataRowVersion.Current) '-- Get the original value of the current row Dim orgValue As String = MyBo.CurrentRow.Item(MyBoFieldNames.MyField,DataRowVersion.Original) '-- To loop through all the rows, checking if the row is dirty, then getting the original values. For Each row As DataRow In MyBo.CurrentDataTable.Rows '-- Get org Value if its dirty If row.RowState <> DataRowState.Unchanged Then '-- Get original values ' Note that the field name is just referenced by its name as a string here. Dim orgValue2 As Integer = row.Item("intField",DataRowVersion.Original) End If Next You will need to do this BEFORE the record is saved. When it is saved, the original values are reset to the current values. I'd also make sure to check AFTER the rules are checked, in case there are broken rules. Likely, I'd do the checking after the rules are checked, save away the results, then take action after the save actually works. I might also do it within a transaction, just in case... Good luck!
	Reply Like 0
Tim Dol	Tim Dol posted 18 Years Ago Post Details Share Post
Group: Forum Members Posts: 340, Visits: 1.4K	Thanks a lot Greg, this will definetly get me started in the right direction. Much appreciated. Tim
	Reply Like 0
Greg McGuffey	Greg McGuffey posted 18 Years Ago Post Details Share Post
Group: Forum Members Posts: 2K, Visits: 6.6K	I'm glad I've been a help! Good luck!
	Reply Like 0
StrataFrame Team	S StrataFrame Team posted 18 Years Ago Post Details Share Post
S Group: StrataFrame Developers Posts: 3K, Visits: 2.5K	Greg is perfectly correct in the use of the DataRowVersion.Original when you call the CurrentRow("FieldName", version) property, but in the AfterSave event, the changes have already been comitted to the DataTable. Even if you change the AcceptRowChangeMode to AfterTableSave, the whole table will have been accepted before the AfterSave event has been copied. The only way that I can think to test this would be to copy the CurrentDataTable before the save. If you use CurrentDataTable.Copy() and store the result in a variable, it will take an exact snapshot of the data in the DataTable and you'll be able to use that to get your original values.
	Reply Like 0

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Threaded View

Original Field Value

Tim Dol - 18 Years Ago

If the field is a normal field, then I believe the underlying...

Greg McGuffey - 18 Years Ago

I checked the current row and the value seems to reflect the changes I...

Tim Dol - 18 Years Ago

Oh, I believe the original value is "gone" in the AfterSave event....

Greg McGuffey - 18 Years Ago

Actually I have been looking at this on a row by row basis, when I...

Tim Dol - 18 Years Ago

To find the original values versus the new values (current values) use...

Greg McGuffey - 18 Years Ago

Thanks a lot Greg, this will definetly get me started in the right...

Tim Dol - 18 Years Ago

I'm glad I've been a help! Good luck!

Greg McGuffey - 18 Years Ago

Greg is perfectly correct in the use of the DataRowVersion.Original...

StrataFrame Team - 18 Years Ago

Reading This Topic

Login
Remember Me Reset Password Resend Validation Email Login

Original Field Value

Original Field Value

Merge Selected

Threaded View

Similar Topics

Reading This Topic

Login

Explore

Messages

Mentions

Search