I got this error:

ElevateDB Error #601 The table signaturen is corrupt (Error reading rows
into cache)

just after changing an index in EDBManager (removing a field from an
existing index) and trying to set the index.property of the table in
object-inspector.

Regards Uli

Uli,

<< I got this error:

ElevateDB Error #601 The table signaturen is corrupt (Error reading rows
into cache)

just after changing an index in EDBManager (removing a field from an
existing index) and trying to set the index.property of the table in
object-inspector. >>

What version are you using ?  Could you send me the catalog/table along with
the pre-alter structure of the index ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<
What version are you using ?  Could you send me the catalog/table along with
the pre-alter structure of the index ?>>

I am using the latest and greatest
Sorry, I don't remember which index of which table it was. When the error occurs again, I'll send you the information you need.

Uli

Uli,

<< I am using the latest and greatest
Sorry, I don't remember which index of which table it was. When the error
occurs again, I'll send you the information you need. >>

No problem, thanks.

--
Tim Young
Elevate Software
www.elevatesoft.com

I just had the same error.
All I did was adding a new index with the ElevateDB manager (unicode).
When I added a new record in the manager, no problem, but when I added one in my test program that uses the table, I got the error.
This is very serious: I can't change nor delete the new record anymore!!!

One key fact to remember - EDBManager is just another app - there's nothing magic about it (with the possible exception of if you're using C++ because its written in Delphi).


With that in mind if your app can't create an index and EDBManager can you're probably doing something wrong.

First check that the code you're using is the same as in Explorer | SQL History in EDBManager.

If it is then make sure the query/script component is pointing at the right database.

If its still not working please post the error message and the code you're using.

Roy Lambert [Team Elevate]

All I did was editing a local table in a grid.
After doing a table repair in the Manager, I could edit one record in my program and then the same error came back.

Then I made this change in my program:
EDBSession.ForceBufferFlush:=true;
Now, the error doesn't come anymore.
So, that's good, but still I would like to know why it came before!

ForceBufferFlush means that data gets written to your disk more rapidly. I have seen this make a difference but only in limited circumstances - generally threads, a dodgy network connection or a hard drive about to fail

Roy Lambert

I also don't understand why "ForceBufferFlush" helped.
I don't do anything with threads in my program, and everything is on a local drive on a one year old pc that doesn't seem to have disk problems...

Van,

<< I just had the same error. >>

The exact same error error message ?

<< All I did was adding a new index with the ElevateDB manager (unicode).
When I added a new record in the manager, no problem, but when I added one
in my test program that uses the table, I got the error. This is very
serious: I can't change nor delete the new record anymore!!! >>

This doesn't sound right.  Are you using the ElevateDB .NET Data Provider ?

Do you still have the table ?  If so, can you email it to me along with the
database catalog (edbdatabase.edbcat) ?

--
Tim Young
Elevate Software
www.elevatesoft.com