Back to SPR List Previous Next
Secondary indexes can become corrupt after adding cases
Moderate Closed - Fixed Found:2002.20.31 03 FEB 2004 Fixed:2002.20.32 04 FEB 2004

DETAILS
 Running the example program will result in a listing that contains duplicate
 entries for a few cases.
EXAMPLE PROGRAM
 retrieval update upstat
 for ii = 90,65,-1
 new case is ii
 new record is employee
 compute name=char(155-ii)+"ian D "+char(ii)+"ronson"
 end rec
 end case
 end for
 end retrieval

 retrieval
 process rec employee indexed by name
 write id(i2) name
 end rec
 end retrieval


 output includes:
 ...
 81Jian D Qronson
 81Jian D Qronson
 ...
 74Qian D Jronson
 74Qian D Jronson
 ...
 67Xian D Cronson
 67Xian D Cronson
 ...
WORKAROUND
Regenerate the indexes after adding new records. A program to regenerate all indexes for the current database is at http://www.sir.com.au/download/reindex.pql
Back to SPR List Previous Next