>Thanks, I checked that out and it is something else that is giving me the problem. I am not using table buffering. For some reason the last record in my view that I update is not being changed. When I Append the view to the table the last row remains unchanged from its original data...
John,
You may not be using data buffering but the views is. Views are always buffered. Your last record doesn't get updat3ed because you never move off of it. The view is in record buffering and it does an implicit TableUpdate when you move off of a record. You need a TableUpdate to update the last record.
It would probably be easier to use buffering all around and do the TableUpdates for all of the records. At least then you won't have the last records acting differently than the others.