Icon View Incident Report

Serious Serious
Reported By: Robert Rowlands
Reported On: 11/3/2010
For: Version 4.30 Build 1
# 3335 Updating Memo Fields in Live Result Set that are Text-Indexed Can Cause Text Index Corruption

I have three memo fields in a table that I use TEXTSEARCH to look for words.

These fields are set for Indexing in the Full Text Indexing Tab in dbsys.

When a user searches one of the fields in the application the appropriate records pop up as having the search word in them. Just as it should.

If I add some more records via the application TEXTSEARCH does not seem to work (on the new records) until I use dbsys to reindex the table.


Comments Comments
The problem was with the fact that the records were being updated navigationally via a live result set. The field positions were moved around in the live result set, which confused the code that determines if the memo field being updated is text-indexed, resulting in the new modifications not being added to the text index properly.


Resolution Resolution
Fixed Problem on 11/10/2010 in version 4.30 build 2


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image