Roy,

App = single user
they look at one of the forms, add a record and after a few minutes they
look again and one or sometimes more than one ***other*** records are
dissapeared.

this actions are made by several hunderds of customers every day, without
any problem.
I checked everything what they do and even blocked off all "odd" handling
and made it fool-proof and students-proof...
It's driving me ( and of course the customer ) crazy !

Erik


"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:B8826E26-4475-4180-96F0-0404586952DA@news.elevatesoft.com...
> Erik
>
>
> I doubt that its windows buffering. If it were then shutting down and
> restarting would probably resolve things.
>
> You can check if its a hard drive problem - defrag the disk with something
> like Norton Speeddisk then validate the tables. If its a hard drive
> problem I guarantee they'll show up corrupted.
>
> How about some more details? EG is the app single user/multi-user file
> sharing/client server. Also what are the users doing when they can't see
> the records, and what were they doing before?
>
> Roy Lambert

Erik


I've just searched the newsgroups and found a few threads about data vanishing. Unfortunately, no resolution was posted for them so I don't know what happened.

It would be worth while searching the web groups yourself - the names to search for are gordon turner and charles bainbridge - and having a read.


Roy Lambert

Roy,

<< I've just searched the newsgroups and found a few threads about data
vanishing. Unfortunately, no resolution was posted for them so I don't know
what happened. >>

Most of the time the issue is a) user-caused or b) a developer mix-up in the
code.  We've never had an instance where DBISAM is physically deleting rows
that it shouldn't.  If Erik has repaired the table and no corruption was
reported, then most likely the issue is one of these two.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


I agree with you, and I know I'm as guilty as all, but wouldn't it be wonderful if people posted to say what had happened

A few do but only a minority.

Roy Lambert

Hi  Roy and Tim,

I also agree Roy.  What Tim says is right of course.

I am trying to get a finger on it, but it is very difficult.
I've made a special version of the app. with some "debug-info lines" added
and have asked this customer to make a backup now and after 7 days (so I can
compare the backups) and in the meantime they must make a list of problems
they encounter (most of the time they remember what was in the records that
are vanished)

I also spoke to a customer who is using this part from 1999. I've told her
how the problem-customer is using the app. and she says that it is ***
impossible*** that records dissapear in that way. She never encountered this
problem...


Erik



"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:70A8A814-3AEC-42D7-82FA-A3D7BCF4B601@news.elevatesoft.com...
> Tim
>
>
> I agree with you, and I know I'm as guilty as all, but wouldn't it be
> wonderful if people posted to say what had happened
>
> A few do but only a minority.
>
> Roy Lambert
>

Erik

>I also spoke to a customer who is using this part from 1999. I've told her
>how the problem-customer is using the app. and she says that it is ***
>impossible*** that records dissapear in that way. She never encountered this
>problem...

Interesting isn't it <chuckle>

Roy Lambert

Erik,

I assume you looked into this (and it is far too simplebut we encountered
this once a long time ago.
The user adds a record, goes to another part of the app (another screen
perhaps) and never POSTS the data.
This would also explain why there is no record of deleted data in your log
(seperate table). The record never existed!

Regards,



"Erik" <bellaard@wega.nl> schreef in bericht
news:3D3AAC2F-CCA3-4044-90C1-580CE7FABD06@news.elevatesoft.com...
> Roy,
>
> App = single user
> they look at one of the forms, add a record and after a few minutes they
> look again and one or sometimes more than one ***other*** records are
> dissapeared.
>
> this actions are made by several hunderds of customers every day, without
> any problem.
> I checked everything what they do and even blocked off all "odd" handling
> and made it fool-proof and students-proof...
> It's driving me ( and of course the customer ) crazy !
>
> Erik
>
>
> "Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
> news:B8826E26-4475-4180-96F0-0404586952DA@news.elevatesoft.com...
> > Erik
> >
> >
> > I doubt that its windows buffering. If it were then shutting down and
> > restarting would probably resolve things.
> >
> > You can check if its a hard drive problem - defrag the disk with
something
> > like Norton Speeddisk then validate the tables. If its a hard drive
> > problem I guarantee they'll show up corrupted.
> >
> > How about some more details? EG is the app single user/multi-user file
> > sharing/client server. Also what are the users doing when they can't see
> > the records, and what were they doing before?
> >
> > Roy Lambert
>
>

Harry,

I known, but the record(s) that dissapear are not the ones just addes to the
database, but are added a few hours or even days before. We have a check on
records in dsEdit/ dsInsert state....

Regards

Erik

"Harry de Boer" <harry@staaf.nl> schreef in bericht
news:2DDF42F1-3403-4679-9280-B5DA38DCE80A@news.elevatesoft.com...
> Erik,
>
> I assume you looked into this (and it is far too simplebut we
> encountered
> this once a long time ago.
> The user adds a record, goes to another part of the app (another screen
> perhaps) and never POSTS the data.
> This would also explain why there is no record of deleted data in your log
> (seperate table). The record never existed!
>
> Regards,
>
>
>
> "Erik" <bellaard@wega.nl> schreef in bericht
> news:3D3AAC2F-CCA3-4044-90C1-580CE7FABD06@news.elevatesoft.com...
>> Roy,
>>
>> App = single user
>> they look at one of the forms, add a record and after a few minutes they
>> look again and one or sometimes more than one ***other*** records are
>> dissapeared.
>>
>> this actions are made by several hunderds of customers every day, without
>> any problem.
>> I checked everything what they do and even blocked off all "odd" handling
>> and made it fool-proof and students-proof...
>> It's driving me ( and of course the customer ) crazy !
>>
>> Erik
>>
>>
>> "Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
>> news:B8826E26-4475-4180-96F0-0404586952DA@news.elevatesoft.com...
>> > Erik
>> >
>> >
>> > I doubt that its windows buffering. If it were then shutting down and
>> > restarting would probably resolve things.
>> >
>> > You can check if its a hard drive problem - defrag the disk with
> something
>> > like Norton Speeddisk then validate the tables. If its a hard drive
>> > problem I guarantee they'll show up corrupted.
>> >
>> > How about some more details? EG is the app single user/multi-user file
>> > sharing/client server. Also what are the users doing when they can't
>> > see
>> > the records, and what were they doing before?
>> >
>> > Roy Lambert
>>
>>
>
>

Hi Roy,

Yes, it's very fascinating what people can/can't do ...

You know, in the 80ies we had a customer with our BASIC ( !! ) application
who could destroy everything. We ( the programmers ) had a chat and we
figured out that this customer could even destroy a program with only one
line:

0010 REM

Erik




"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:7176A664-B920-4952-A192-3C9FAC5EEA95@news.elevatesoft.com...
> Erik
>
>>I also spoke to a customer who is using this part from 1999. I've told her
>>how the problem-customer is using the app. and she says that it is ***
>>impossible*** that records dissapear in that way. She never encountered
>>this
>>problem...
>
> Interesting isn't it <chuckle>
>
> Roy Lambert

Confirmation is not an audit log. The key is to record that they did
something, so you can show it was done (and how preferably) later.

/Matthew Jones/