If you're sure these are the only six then you could copy them to a temp file with a (D option and then copy them back - assuming you don't have any triggers that this would confuse.
To be very sure you could also delete all of the indices and rebuild them. There is a guide_ndx, I can't remember exactly which version it came out in, it may have been 6. It would also find these records. hth Colin Alfke >-----Original Message----- >From: Karjala Koponen > >We are running UniData 5.2 on AIX 4.3.2. > >I have defined 16 alternate indices on a file. > >I have always ASSUMED (why?) that when a record is written >that all indices >are updated, even when values have not changed. I have run >into some index >behavior that shows that I am mistaken and that the index code >includes such >efficiencies that the index process doesn't bother looking at >values that do >not change. > >When I do a select on any of the fields that would be set a >record creation I >fail to find a set of six sequential records. I assume that >the index was >disabled during that time (presumably by me :( ) However, >when I search on >fields, such as the invoice date, that would have been updated >later I do find >the records I expect. > >I will now write a process to compare the records that I get >with one of the >indices set on record creation with the set of all records so that the >accountants can reconcile their reports. > >Karjala ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
