Reported By: Peter Anderson Reported On: 8/11/2004 For: Version 4.10 Build 1
# 1811Live 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 and WorkaroundsThis 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.
ResolutionFixed Problem on 8/12/2004 in version 4.11 build 1