I don't know if its just what I'm doing in this particular case but.....

Writing a small app to convert a load of data I copied off the web. The data obtained by cut'n'paste resides in a memo field in a table. I'm analysing and deduping it into another table. During the process I'm crashing the app lots either via resetting the program in the IDE or via typos (eg field name not found).

What I have found is that the table is corrupting far more often than I'm used to in these circumstances, at least when I was using D6.

Both tables are opened exclusive.

Anyone else seeing this sort of thing?

It might just be be and this particular app!

Roy Lambert

Just tried with FlushBuffers after each post and its slooow but fine.

The error I'm getting BTW is 8961 headers corrupt.

Roy Lambert

Roy,

<< Both tables are opened exclusive. >>

Exclusively-opened tables will corrupt very easily if you kill the process
because the buffers will get flushed to disk occasionally, but not the
header.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


That explains it then - I rarely open tables exclusively - in this case I did since I want to EmptyTable.

Roy Lambert

Roy,

<< That explains it then - I rarely open tables exclusively - in this case I
did since I want to EmptyTable. >>

Just do the EmptyTable, and then open the table normally.  You don't need to
explicitly set Exclusive:=True to use EmptyTable.

--
Tim Young
Elevate Software
www.elevatesoft.com