Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Lost Data from File
Mon, Mar 13 2006 2:46 PMPermanent Link

Gordon Turner
I have received two different calls about a customer losing entries that
they have created on a previous day in my application.  The app itself
uses 13 different tables, and the data is only lost from one.  Here are
the specifics (at least for one instance) - D7, DBISam 3.24 for the app.
 Workstation - XP Pro SP2 - data files located on a W2K server using MS
networking.

In the data module, I use a common event handler for the AfterDelete,
AfterInsert, and AfterPost that executes the following:

procedure TDataMod.BufferFlush(DataSet: TDataSet);
begin
  if not fSkipBufferFlush then
    (DataSet as TDBISAMTable).FlushBuffers;
end;

The fSkipBufferFlush is a flag I use to avoid the flush when I'm
performing a data import function.

Files are all opened in Shared mode (it's a multi-user application), but
in both cases, the user was the only person working in the app at the
time of the data loss.  I examined the file for one customer and it did
not show any signs of corruption (no change in the number of records
when I ran the repair utility).  The file in question would not have
more than 2000 entries - if that many.

Is there anything in any of this that could account for lost data?  Not
just a single record or two, but a whole data entry session worth of data.

Gordon Turner
Mon, Mar 13 2006 5:00 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Gordon,

<< Is there anything in any of this that could account for lost data?  Not
just a single record or two, but a whole data entry session worth of data.
>>

Have you verified that there wasn't an improper shutdown and that the table
is not corrupted ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Image