Icon View Incident Report

Serious Serious
Reported By: Greg Hallam
Reported On: 12/15/2017
For: Version 2.26 Build 7
# 4608 Cached Updates Causing Error #1007 Errors when BLOB Columns are Edited

In summary here is what I do:
    - set filter to the one record I want to edit (to reduce the size of the temp table)
    - BeginCachedUpdates on that table
    - call Edit on that table
    - ... take my time editing ...
    - call Post on that table
    - ApplyCachedUpdates (error will be provided if changes have occurred)
    - remove Filter

It had been working fine until it didn't.  In a particular table I kept getting errors "ElevateDB Error #1007 The row has been deleted since last cached for the table Product".  After researching further and guided by a recent bug fix I remembered about Cached Updates and memos, I focused there and this is what I have found.  It doesn't seem to matter if there are memo fields in the table or even in the edit until you edit a memo field as part of a cached update.  After that the error above keeps coming up regardless of whether the memo field is edited.


Resolution Resolution
Fixed Problem on 12/17/2017 in version 2.27 build 1


Products Affected Products Affected
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image