Icon View Incident Report

Serious Serious
Reported By: Sean Smith
Reported On: 6/25/2001
For: Version 2.10 Build 1
# 810 Running Live SELECT SQL w/ Calc Fields, Editing Record, and then Running a DELETE SQL Causes Error

The problem is when you have a query on the report, and set it's RequestLive property to true, and then run the report, after it is
destroyed, if you try to run a different query that deletes records out of the same table, it gives you the DBISAM_KEYORRECDELETED (8708) exception.

Comments Comments
The problem was related to the live query with the calculated fields in the SQL itself. This caused the logical record size to change for the table in question and the engine was not handling this change properly and comparing record buffers after this point based upon an incorrect logical record size.

Resolution Resolution
Fixed Problem on 6/25/2001 in version 2.11 build 1