Icon View Incident Report

Minor Minor
Reported By: Eduardo Helminsky
Reported On: 2/3/2005
For: Version 4.16 Build 1
# 1953 Live Query SQL WHERE Condition with Only Constants Can Cause 8965 Page Buffers Corrupt Error

I have some code with the following SQL statement. I process some operations and then delete all the records. After that I have to call the same SQL again. After that I received #8965 error.

select * from hcus where true order by des

Comments Comments and Workarounds
The workaround is to use more than just TRUE as the WHERE condition and either remove it or use actual column comparisons in the WHERE clause.

Resolution Resolution
Fixed Problem on 2/4/2005 in version 4.17 build 1