Icon View Incident Report

Serious Serious
Reported By: Peter Anderson
Reported On: 8/11/2004
For: Version 4.10 Build 1
# 1811 Live Queries with Calculated Expressions On Encrypted Tables Can Cause Garbage Records To Appear

Execute the live query below. Then I do [Ctrl][End] and [PgUp] a few times it looks like garbage in some or all of the records.

select cust_no, firstname+' '+lastname cust_name from customer

Comments Comments and Workarounds
This problem is only a display issue and the garbage records cannot be modified anyways without receiving an #8708 error. The only workaround is to not use calculated expressions with live queries on encrypted tables.

Resolution Resolution
Fixed Problem on 8/12/2004 in version 4.11 build 1