"when accesing the table via failed index" Is it one index that gets
corrupted? What type of index or record? autoincrement, variable, etc.?
Is there a reason for different client versions? What version format
are the databases?

Hi !

There is quite many tables in our database. Some of them are frequently
updated and those are the tables that fails the most. Almost all tables has
more than one index - or, perhaps, I should say "key" because this is the
type of index which is updated automatically on every table update. There
are no rules in index failing and it is not the same index every time. There
is only a few autoincrement indexes, but it is maintained via the program
(we are using Clarion for Windows 5.5, soon it will be CW 6.1), so I guess
there is no real autoincrement indexes. Table format is 7.x because our
clients are mix of Pervasive 7 and 8. And one more thing may be important -
we are using Pervasive as relational database, not the transactional one.

HTH,
Hrvoje Grcic, MCP


<jbuttery (AT) sqnbankingsystems (DOT) com> wrote

Sometimes we can be successful in analyzing corrupted files with our
own internal tools and give you a good idea what is happening. If you
have two sampele files that you can submit, you can send them to me via
Email. If they are huge, let me know and I'll get you information on
our FTP server.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Coming Soon: Pervasive DataExchange Training!

Hrvoje Grcic wrote: