Thanks Bernie for the heads up on Reload..
I will follow the UNLOAD, LOAD for further rebuilds.
This database has been in operation for many, many years without reloads or much maint at all.. I know .. shame, shame, but time is not a luxery right now.. Soon I'm going to sit down and right a routine I can schedule to run after hours..
Jim
Bernie Corrigan wrote:
Jim -
RELOAD is not the equivalent of UNLOAD ALL
followed by running the file that the unload was directed into to rebuild the db. For some reason,
and I don't know why, RELOAD will preserve some instances of corrupt data through the reload process. I have never found that corrupt data
can survive the UNLOAD ALL and rebuild process.
Bernie
At 08:12 AM 5/28/2004 -0400, you wrote:
Rob
We are entering data using a tiered region as well.. for the items. I issued a reload statement and then an autochk and then deleted tables and ran autochk again and errors were gone. I have to admit I don't know the differences in what happens behind the scenes when commands like RELOAD, UNLOAD SCHEMA, UNLOAD DATA and such. I figured RELOAD would be equivelant to UNLOADing SCHEMA and then DATA and then LOADing them.
I did not recreate the tables, because as far as I know they were for some kind of temporary reporting most likely.
Jim
Rob Vincent wrote:
Hey Jim,
I experienced this type of problem data-entry problem on a form with tiered regions in RB65++ Win (1.842)
The problem did not appear to be related to the database engine but corruption in the database files themselves.
I resolved with the following procedure: - UNLOAD data from affected table to a file. - DROP the table from the DB schema. - Re-create table. - LOAD data from exported file back into table.
Usually the data will export fine, and it is just the definition that is causing the error.
--- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body, place any text to search for.
================================================
