Our client have an application running under IB 6. And there are 2
problems which are similar.

1. Some records will be added after some table after insert/update
trigger. Normally , those records have been added without error. But
sometimes later like 1 week or couple of months , i can not predicted.
Some records was missed. Actually , the record was missed because of
index corruption . Like

Select * From Sin_Det where sino = 'A-1'

records shown
1
2
4
5

but if i use Select * From Sin_Det where sino||'' = 'A-1'

all records shown corrected
1
2
3
4
5

2. Some Records added by front-end application. But above problem also
occurs

I check the server and do not find any hardware failure error non IB
error in IB log.

Is there any body can give me some advice?

Server : Window 2000

thanks in advance

kamen lai