Hi

(Version 3.30 on Delphi 5)

Since a recent update we have been getting a lot of #8965 errors (Index page buffers corrupt in the table 'main').

Users see the error when they do a search on the database.  I'm not sure if the search causes it or that some corruption happens prior and it only surfaces when they do a search.

The search is uses SQL like the following:

'UPDATE "D:\Testing_Other\DB\Test_DB\main.dat" M2 set GroupHit=6361 FROM "D:\Testing_Other\DB\Test_DB\main.dat" LEFT OUTER JOIN "D:\Testing_Other\DB\Test_DB\link.dat" L2 ON
(M2.Index = L2.UserID) WHERE (L2.GroupID IN (23))'

(And the table is then filtered by GroupHit).


I can't reproduce the problem on our systems.  I would appreciate any suggestions on things I should look at.


A number of things have changed since the problem arose, but the only thing that I think could be problematic is the changes I have made to Session handling.  Previously I had a specific
TDBISAMSession component.  My tables and database component had the SessionName of this session, but my query components had a blank SessionName (so presumably used the default
session).

In the problematic release I had removed the TDBISAMSession component, and changed the SessionName for the database and all query and table components to "default"

So presumably that change is causing the problem???  I could try adding back the session component and pointing just the tables to it as previously.  But if that is the cause I would like to understand
why so that I don't make a similar mistake in the future.


Thanks

Dave

Dave,

<< Since a recent update we have been getting a lot of #8965 errors (Index
page buffers corrupt in the table 'main').

Users see the error when they do a search on the database.  I'm not sure if
the search causes it or that some corruption happens prior and it only
surfaces when they do a search. >>

I can email you a modified dbisamen.pas that will fix this.  Please send me
a private email and I'll reply with the unit.

--
Tim Young
Elevate Software
www.elevatesoft.com