Thanks Albert
I have an option on our start up RBA menu that does that, and I told them to
give it a try but count the rows before and after to see if they loose
anything.
I have a dozen offices using this same App in the same area and none have
this problems, just this one office. So, I know RBase is not at fault but I
can not figure out what this user may be doing wrong and if there is
something I need to change in my App to prevent them from doing this again.
Marc
--------------------------------------------------
From: "Albert Berry" <[email protected]>
Sent: Thursday, February 03, 2011 4:45 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - Re: Data corruption in a Varchar
I think you need to unload/reload, Marc. Anything else might truncate the
file.
Albert
On 03/02/2011 8:35 AM, MDRD wrote:
I do not feel this is an RBase problem. About every 4-5 weeks this 1
office has DB corruption in the same table. They have a very good
computer tech and we have worked together before but so far nothing we
have done has stopped this. They even bought new computers.
I have several offices using this same version without problems, I can
not think of anything the user could be doing that would cause this or
how to prevent the user from doing something wrong. This is about the
6-7 time this same office has had corruption in the same table. Since it
is so infrequent it makes it hard to pinpoint what is the problem. Of
course they never reboot the computer while in RBase or nothing like that
LOL
It seems funny there is an error but at the bottom it says No errors?
Autochk Full shows this
Examining LOB data in Travcard
-Warning- Column Subjx at rowid 175104001
has data length 0, expected 538976288
....
Database statistics
....
....
No errors found.
Thanks for any suggestions
Marc