Re: Conceptual subfile question

[Booth Martin <booth@xxxxxxxxxxxx>]

Your response is a great response and is well said.

I'd add this:  I define a data structure made up of the input-capable 
fields on the screen and also define a field named OrigFields.  When I 
write the subfile record I also populate OrigFields, which becomes a 
hidden field in the subfile record.
That provides:
- an easy two-field compare,
- allows an easily implemented F5-Refresh,
- an easy way to check if any updated fields were changed at another 
work station in the interim between the unlocked read and the locked chain.

On 5/3/2016 8:04 AM, Mark Murphy/STAR BASE Consulting Inc. wrote:
> ... To determine if a record is changed, I simply keep hidden copies of every input field, and compare the saved value to the input field. Those hidden copies are loaded with the subfile record, and do not change until I save the subfile record out to the database.  ...