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




Reply via email to